u/Financial-Fondant902

▲ 18 r/SQL

I struggle with SQL interviews

I’ve been working with SQL for years and recently discovered that my issue in interviews is the terminology. For example, if an interviewer shows me an excel spreadsheet with two tables and asks me how to pull x information from it, I get nervous and end up articulating the answer very poorly, leaving out key words such as “joins”. Another example is if they asked to show it using a CTE, and this term would confuse me during the interview, but after the interview I’ll realize that I’ve written many queries that use CTEs. My question is how do I fix this? How do I prepare for such questions better? Are there any sources or tips or general advice that anyone has? I’ve not found any site that gives practice on the excel-style of questions

reddit.com
u/Financial-Fondant902 — 18 hours ago
▲ 42 r/JinshiandMaomao+1 crossposts

Collab with Rinderon Cream (Video link in description)

Kusuriya no Hitorigoto did a collab with Rinderon cream, and Jinshi/Maomao are promoting it!

Here is a link to part 1: https://youtu.be/pf1Hc-J9CC8?is=h3bYNyZNTIJoFW1z

Part 2: https://youtu.be/wxTSxVmEvb4?is=1YEFyAITwsrdzxK2

Captions should be able to be turned on. Basically Jinshi is asking MaoMao to provide a cream for the child’s itchy hands, and MaoMao explains how the cream works. In part 2, she explains how to apply it. They sing a cute little song at the end!

u/Financial-Fondant902 — 11 days ago
▲ 109 r/JinshiandMaomao+1 crossposts

Official Nekokurage Art from latest volume: MaoMao trying to not disturb Jinshi as she reaches for her herbs ❤️

Credit to @keiuzuki for sharing

u/Financial-Fondant902 — 14 days ago

Explanations of the Season 2 Frog Scene and Carriage Scene

Hi all! As with the “MaoMao’s feelings for Jinshi” post, I wanted to share the following explanations of the Frog scene and carriage scene to help fill in any context for anime-only watchers. As with the other post, this explanation was written by someone else who is no longer on Reddit but gave me permission to share, and I am sharing it because it is a question that comes up far too frequently in other spaces of the internet. If you ever wish to use this explanation to help new fans understand the scenes, absolutely feel free to. We only ask that you ensure to copy/paste the text instead of crossposting. We discourage crossposting and/or linking any posts from this subreddit to any subreddit apart from the JinshiFanClub subreddit because we are trying to keep both subreddits as private, positive, safe places reserved exclusively for JinMao/Jinshi fans and for fans that understand that MaoMao canonically loves only Jinshi and vice versa. Happy reading/watching! (Also shout out to you folks who are already sharing these sorts of explanations with other fans 👏👏👏❤️❤️❤️)

“Both the frog scene and the carriage scene were examples of Jinshi dealing with puberty for the first time ever. Jinshi has been in an aphrodisiac state of mind (similar to the state of mind Basen was in when he ate that turtle) ever since season 2 episode 10 due to suddenly stopping his eunuch meds and being forced to deal with multiple years of puberty hormones at once. This means that he was super aroused and not in his normal state of mind at all. He will continue to remain in this condition until MaoMao gives him a special treatment in season 3. All of his actions in these scenes were reactions to MaoMao’s actions. That’s also why he initially tries to keep a distance from Maomao in the two mentioned scenes. A running joke of this section of the series until Jinshi gets his new hormones in check is that MaoMao keeps accidentally activating his frog while he’s in the aphrodisiac/fresh-puberty state and he has no idea how to handle it due to never having an active frog (b0ner) before, which is seen in the frog scene, the carriage scene, and a scene in season 3.

Regarding the carriage scene, Maomao unexpectedly compliments Jinshi. He makes a face as he feels his frog come alive (second b0ner ever), lets go of MaoMao’s wrist to keep a distance from her, makes a worse face and stares at the ceiling in the carriage scene as he tries to get his frog back under control, but then MaoMao moves into his space and he loses control again. These scenes are supposed to be more comedic than anything else but the anime really fails at delivering comedy, at least in season 2. So these scenes are all a result of MaoMao activating his frog when he’s never had puberty before and has no idea how to handle an active frog. MaoMao gave Jinshi his second b0ner ever in the carriage scene and his first b0ner ever in the frog scene when she squeezed tf out of his frog multiple times

Regarding the frog scene, here is another summary which explains it best: “He was not going to force himself on her and anyone who thinks or says otherwise does not understand his character at all. He did not have a plan: He only wanted to scare her and get her to stop lying (aka agree that it wasn’t a frog). This was his impulsive reaction to their banter, which is why MaoMao’s immediate line is “Crap, I provoked him too much”. She was fully aware that he was just reacting to her words.

Let’s recap what led up to this scene:

- Jinshi has been desperately trying to tell MaoMao his identity for days
- They end up in a situation where MaoMao rub/squeezes Jinshi’s frog repeatedly and finds out part of what he wanted to tell her: that he is not a eunuch. Note that she squeezed it even after he told her to let go and after she realized what she was squeezing. He further was fresh off his eunuch meds and experiencing puberty all at once, and she essentially gave him his first active frog (b0ner) ever with all the squeezing and stripping. Also note that MaoMao was worried that Jinshi would hear her heart pounding in this scene, but the anime left out this line
- Jinshi (who is now turned on, embarrassed, and also relieved that she partially knows): sits up to have a serious discussion with her about his identity
- MaoMao completely ignores him, interrupts him, insults his manhood by calling it a frog, and then insults the size of it
- Jinshi, annoyed af about everything MaoMao said and did up until this point as well as about the fact that MaoMao is not listening to him at all, places her down and asks her if she wants proof
-

.. This was Jinshi’s way of getting her to stop fooling around and listen to what he was trying to say. Words were not working with her so he resorted to this action. It was a full-blown impulsive reaction to send her two messages: “Please listen to what I’m trying to tell you” and “You should see me as a man, not a eunuch”. The leg grab also had 2 purposes: serving as part of the “see me as a man” message and also hardcore flirting.

After reaching this position, he hesitates for a second (this is the part where his face grimaces). He then moves closer for a kiss, hoping that MaoMao would say something. As soon as MaoMao acknowledged that it’s not a frog or told him to stop, he would have stopped. But she didn’t. She was shocked at first but then decided to relax her body, close her eyes, and her lips for a better kissing angle. Jinshi did not expect this but then followed suit with his own lips. Notice that his hand was trembling the entire time while hers remained calm. And then the dog barked and snapped them out of their trance, reminding her of their status differences. While waiting for the dog, Jinshi had released her leg, but her leg was still up in the air. Further, she did not think about Jinshi’s actions even once after the incident (these are her exact words). She instead kept worrying about how she actually hurt him and squeezed his frog.

Jinshi has been dragged away to be SA’d in the past, so he would never do that to MaoMao. He also never lost his VCard, and even though he’s frequently eager to initiate romance with MaoMao, he quickly turns into “babygirl” because he can’t handle her in bed (she’s a permanent top while he’s a permanent bottom, at least with her). The maximum he would have done in this scene is kiss her and that’s it. Anything further than that would require initiation from her because he would probably be too embarrassed to continue”

reddit.com
u/Financial-Fondant902 — 22 days ago

For new Redditors

Hi all! We wanted to share this info for anyone who is new to Reddit:

This group allows NSFW posts, so if you are into that, please make sure that your Reddit settings allow these posts to show up for you. Two things need to be done to accomplish this:

  1. Within your Reddit account, head over to your Reddit settings > Profile Curation > make sure the NSFW toggle is selected

  2. Within your phone settings, head over to the settings managing your Reddit App make sure that NSFW posts are allowed

If both of these settings aren’t updated then posts marked as NSFW be completely invisible to you. The instructions above apply mainly to users who use Reddit on mobile/iphones. The instructions will be different for those who use other devices.

We are sharing this not just for this subreddit but for all of Reddit in general. I recommend making these changes even if you’re not interested in NSFW because failing to do so will block you from accessing all nsfw posts. The posts will always be blurred whether you have this option active or not, so you do not need to worry about seeing these posts against your will by having these NSFW settings active.

reddit.com
u/Financial-Fondant902 — 26 days ago

For new Redditors

Hi all! We wanted to share this info for anyone who is new to Reddit:

This group allows NSFW posts, so if you are into that, please make sure that your Reddit settings allow these posts to show up for you. Two things need to be done to accomplish this:

  1. Within your Reddit account, head over to your Reddit settings > Profile Curation > make sure the NSFW toggle is selected
  2. Within your phone settings, head over to the settings managing your Reddit App make sure that NSFW posts are allowed

If both of these settings aren’t updated then posts marked as NSFW be completely invisible to you. You won’t even know that those posts were posted. The instructions above apply mainly to users who use Reddit on mobile/iphones. The instructions will be different for those who use other devices.

We are sharing this not just for this subreddit but for all of Reddit in general. I recommend making these changes even if you’re not interested in NSFW because failing to do so will block you from accessing all nsfw posts, and this includes posts that are not that severe in nsfw but are marked as such as a precaution. The posts will always be blurred whether you have this option active or not, so you do not need to worry about seeing these posts against your will by having these NSFW settings active.

reddit.com
u/Financial-Fondant902 — 26 days ago
▲ 264 r/JinshiandMaomao+1 crossposts

For those who don’t know, Len Barboza is an artist who used to do a lot of Inuyasha x Kagome artwork. They have now started doing JINMAO!!! 😍 I am so excited!!!!🤩🤩🤩

u/Financial-Fondant902 — 28 days ago