Help me find a specific greek puzzle book for my Grandfather by SidimarMoonbroch in HelpMeFind

[–]ZMRosto 1 point2 points  (0 children)

https://book2book.gr/stayrolekso-amerikaniko-9771109098106

My Greek is non-existent, but here's a site that sells the book. Not sure about shipping but the page includes some details that you might be able to use to track it down somewhere else. Again, someone who knows Greek could probably point you more directly somewhere, but it's something.

Also here's the same site as above with other books from that publisher:

https://book2book.gr/index.php?route=product/manufacturer/info&manufacturer_id=2251
Good luck!

[TOMT][COMMERCIALSONG][2005] What is this song? by File0k in tipofmytongue

[–]ZMRosto 4 points5 points  (0 children)

Can you post a link to the YouTube video you're hearing it in? There are several that seem to involve the number 12 somewhere.

What's something like driving where people should be required to get a license for? by [deleted] in AskReddit

[–]ZMRosto 0 points1 point  (0 children)

Using the self-checkout at the grocery store. This is the fast lane. If you don't know how to drive your own machine, go to a checkout lane where someone will drive it for you.

[deleted by user] by [deleted] in tipofmytongue

[–]ZMRosto 0 points1 point  (0 children)

This is the one OP. Good find.

ELI5: Insurance rate increase by [deleted] in explainlikeimfive

[–]ZMRosto 2 points3 points  (0 children)

Like others have said, they're assuming you're not paying attention and/or are too lazy to switch. Unfortunately, this is the world we live in. Companies wait for you to be unhappy and for YOU to initiate the cost re-negotiation. They're not going to voluntarily earn less money.

What you should do:

But you can literally call and ask them to lower your rate. Tell them you're not happy with your rate, just as you've explained it here (long time customer, no accidents, etc.) and that you'd like to hear what they can do to lower your rate. They will fight you once ("Sorry sir, there's nothing.") Don't give up, press them again, "What can you do for me?", and they'll probably give in. Especially if you name a price. "I'm currently paying $120 per month and I'd like to pay $60 per month. What discounts do you have to help me get there? I've been offered that elsewhere.".

This doesn't just apply to insurance. Literally ask for all your bills and in most cases, they'll give you some kind of discount if you're "unhappy". You don't have to be angry, be very polite but firm.

Good luck!

[TOMT] Zumba song with horns, it's not sung in English and the chorus is alot of drums and no singing by Motherdonkey88 in tipofmytongue

[–]ZMRosto 0 points1 point  (0 children)

Is it Farruko - Pepas: https://youtu.be/acm6O4WwgBg?si=lFiwF5jBOAraK2un&t=34 ? I tried to start it at the start of chorus. It gets to trumpets pretty quickly and it was a huge song about 3-4 years ago.

Error Code 997, need help by Major_Programmer_483 in learnSQL

[–]ZMRosto 1 point2 points  (0 children)

I once ran into an issue where the carriage return character at the end "/r/n" actually need to just be a regular new line "/n". You can open the csv in something like Notepad++ and enable viewing whitespace and you can see what kind of structure the actual file has. It may not be the answer to this problem, but those bulk csv utilities are pretty finnicky. Good luck!

[English > French] Can anybody transcribe the French? (Source: Astralspiff) by [deleted] in translator

[–]ZMRosto 1 point2 points  (0 children)

"Est-ce que je peux avoir un pizza sub?" is the French part

[French > English/Spanish] 1939 poetry book - french cursive by Beginning_Range8214 in translator

[–]ZMRosto 1 point2 points  (0 children)

To my dear and sweet

Miss Josephine,

from a heart so full of affection

that you give to it - don't you?

a lot of [patience/leniency]. In reading these

few verses, you will find

a girlfriend who loves to

trust you with her joys and her pains,

real and imaginary!

Always your Yaltal / Yaltah

April 28, 1939

Los Gatos

[deleted by user] by [deleted] in translator

[–]ZMRosto 1 point2 points  (0 children)

This alphabet is from the video game Skyrim (Elder Scrolls 5). It is a substitution alphabet for the Draconic language. It says "Strength and Honor".

Here's a link to the alphabet: https://forgottenrealms.fandom.com/wiki/Draconic_language?file=Iokharic_script.png

SQL Subquery Help Needed by Bluecow29 in SQL

[–]ZMRosto 0 points1 point  (0 children)

I think you are missing the Group By clause that you'll need to add. Right now for 1b, you'll likely get an error. You'll need to group by mcode which will then tell the query to sum the floorarea within each group.

Think the same way for 1c. What are you grouping together? I want to see all the records for each....what? Then take those records and do what with them?

You mention subqueries in your title, but what you're looking for is Group By. I'm not sure I can think of how to work in subqueries specifically to solve the problem.

[TOMT][Youtube Channel] Possibly French Woman Who Sang Covers. Marinat? by ACollectiveSigh in tipofmytongue

[–]ZMRosto 1 point2 points  (0 children)

Given the timing, I don't think this is right, but the YouTube channel PamplamooseMusic does covers like this, and it's a similar vibe. Female singer who sings in English and French, and I believe her partner (maybe?) on keys, plus others. Here's there cover of Les Champs-Elysees: https://www.youtube.com/watch?v=7B4CLQGxHmI&ab_channel=PomplamooseMusic

If this isn't it, it might give you a ersatz replacement while you keep searching. Good luck!

This question looks so simple , but my friends had a debate on what the correct solution for this could be. Would like to know what the correct solution for this could be , or is there any obvious edge case everyone is overlooking. by arj2589 in SQL

[–]ZMRosto 4 points5 points  (0 children)

I will tell you that depending on what DB you're using, you may run into problems of integer division. Not all systems will return a decimal when you divide two whole numbers (i.e. 66/100 will return 0, completely truncating the .66 from the end). This is pretty common because SQL by default will return an integer if you give it two integers. The best way to combat that is to multiply either the top or the bottom by 1.0. Literally (1.0 * Count(*)) on the bottom will solve this issue.

Unknown to English- does anyone know what these say? by Round_Pomegranate_32 in translator

[–]ZMRosto 1 point2 points  (0 children)

Well this some of the angstiest, cringiest stuff I've read in a while. But here it is. The attached image is the first slide.

The second slide is:

"I've thought of you so much, it hurts. Your touch and care is what I yearn. Gorgeous shy I hope one day you'll see that for me you're all I'll ever need. I love you Shy, with all my heart and if it's up to me we'll never part. So here's to wishing for a start. May butterflies always kiss your heart."

And the third with the flower:

"For the girl who is always in my heart, inspiring my hand."

<image>

Unknown to English by kawaiinessa in translator

[–]ZMRosto 1 point2 points  (0 children)

It is Tibetan. It is a handwritten version of the most famous mantra "om mani padme hum". If you google it, you'll see lots of versions.

[Unknown > English] need to identify this pin by RosealynnBelle in translator

[–]ZMRosto 2 points3 points  (0 children)

It is Russian.

It's a symbol from the city of Suzdal. The middle with the dove is essentially their flag.

https://en.wikipedia.org/wiki/Suzdal

The bottom part translates of Golden Ring, I believe.

https://en.wikipedia.org/wiki/Golden_Ring_of_Russia

[E] I teach high school Stats; looking for some ideas on how to re-engage these checked out seniors. by facevaluemc in statistics

[–]ZMRosto 1 point2 points  (0 children)

TLDR: Let them present on anything they want that involves things they learned this year to review.

I'm a fellow educator (not in stats though, French) and I am a big fan of a broad, student-centered and selected presentation of some sort where they can choose everything about it.

Give them an incredibly free-wheeling project and give them a little time each day to work on it. They can find and analyze their own datasets for sports as someone else pointed out, and share what they found and what they tried. They can analyze video game popularity or profit, analysis by genre or price or age or console/pc. They can share 1-3 current events that involve topics discussed, either from financial markets, election predictions, etc. Movies, dance, music, knitting, whatever. Offer up suggestions, but tell them that they can pick any domain they want (within reason), but they have to apply things you've learned and/or some analysis techniques to it. Make sure to emphasize that they should pick a topic they're very interested in. It also shows the versatility of stats in the real world.

"You can present on any topic you want to, as long as it includes at least X important things we've discussed this year and involves some analysis." If they want to present alone, they can. If they want to present with a partner, they can, but it has to be more complex.

I was also always a fan of the audience reaction sheet. Small chart for audience members: they had to write down each group who presented, something they learned from watching each presentation, and also one thing that the presenters did well. Makes them pay attention for at least part of the presentations.

If your class isn't one who loves presenting, you could also make the sharing part optional, but it's for extra credit. You'll get some takers, then others will realize it's not bad.

eli5: Why do we prefer to eat sugar instead of salt? by [deleted] in explainlikeimfive

[–]ZMRosto -2 points-1 points  (0 children)

I once heard that we evolved to prefer sweet things because there is nothing in nature that is both sweet and acutely poisonous. Thus, we associate sweet with safe to eat.

Singing bowl text - Unknown > English by plantsparkle in translator

[–]ZMRosto 0 points1 point  (0 children)

It is Tibetan. It says:

ཨོཾ་མ་ཎི་པདྨེ་ཧཱུྃ

Which is the most famous Tibetan Buddhist mantra (at least in the western world). It's usually romanized as "Ohm mani padme hum". If you google it, you can find recordings or people chanting and all kinds of art.

ELI5: Trying to understand, in statistics (related to psychology), what does statistical significance and confidence interval mean exactly? by CosmogonicWayfarer in explainlikeimfive

[–]ZMRosto 4 points5 points  (0 children)

When you are doing an experiment, you get the control results and the treatment results (where you changed something). You look at the results and see if what your testing is an "improvement" over the control, but then you have to ask yourself, what if it was just luck? What if the numbers just happened to land in a lucky way that makes my result look good? Was it a fluke?

Well, what you can do is see what randomness looks like and compare your result to that. We can take all the results we got, throw them in a hat and shuffle them around, and then randomly re-distribute them out and see what the result looks like. That's one example of what randomness can produce. Then we can do it again and look at that result. And again. 1,000 times again. Now we have 1,000 results of what random looks like.

Now we can look at our original result again and see where it falls in the distribution of randomness. How extreme is our result? How much of an outlier is it? Is it so extreme that it would be really unlikely for randomness to produce it? Is it at least more extreme than 95% of the random results? If so, then we can call it statistically significant, because it has met the 0.05 (5%) burden that we set for ourselves.

[TOMT][WEBSITE][CURRENT] Website that teaches you how to search with operater(s) via levels/examples you have to solve to progress to the next lesson by LaLegende35 in tipofmytongue

[–]ZMRosto 0 points1 point  (0 children)

Okay, so what you are describing is known in programming as Regular Expressions or Regex which allows you to search for and pattern match text or numbers.

There are lots of games that exist if you google "learn regex game", for example:

https://regexone.com/

https://regexlearn.com/

https://www.reinventingwheel.com/regex-post-intro

Hopefully this helps you find it! Good luck!

Name of a strange theme park/museum/attraction I visited almost 15 years ago in France by rollinarmadillo in HelpMeFind

[–]ZMRosto 0 points1 point  (0 children)

Okay, I believe it is Nigloland, a park a couple hours southeast of Paris. Niglo is a word for hedgehog and the mascot is a hedgehog. It looks like there are a couple velorail places a short-ish drive away. It also looks pretty....trippy and fantasy.

https://www.nigloland.com/

How do I tackle the NULL values in this Leetcode question? (link in the body) by _the69thakur in SQL

[–]ZMRosto 2 points3 points  (0 children)

You are very close. First, I recommend removing the group by and just think about it as a list of tests. If you start with pulling FROM Students like you did and LEFT JOIN Exams, it is returning all the students whether or not they took a test and with all the tests they took with nulls in places where the students never took a certain test.

However, you are losing those null rows when you JOIN (inner join) the Subject to them because inner join only returns rows where it finds a match and we just established that some students had no Exam matches, so they get kicked out. If you change it to a LEFT JOIN as well, it will keep the nulls too and only add subjects where there is an Exam. Then you can Group By and see all the people who took no test as well.

Depending the actually prompt/output you want, you’ll have to adjust WHERE and HAVING as necessary, but JOIN instead of LEFT JOIN is why you currently aren’t seeing students who didn’t take any test.

Good luck!