Functions | SQL | Tutorial 14

[ramzisiliman]

Thanks bro for your tutorials. They have been the best of all that I have tried to attach myself to. Keep us updated.
Lots of appreciation to Giraffe Academy

[Be_Khaos]

Fuck I'm an idiot.
Mike at 3:57: "That's probably because David Wallace makes 250 grand a year."
Me: David Wallace... Where do I know that from? Oh! The Office! Coincidence i guess. *Looks at the other names* Nope they're all there, I'm an idiot.

[sintunayehu]

This is Great. The best place to start SQL. Thanks Man!

[weedosutra]

Thanks for sharing..very helpful! Love the "Office" employees! :)

[jaigandhi]

his code that was originally copied was birth_day not birth_date - make sure you know that

[myHellnet]

Hi, I'm following your series of tutorials and I have a question for you. I'm in this line of code
SELECT SUM(total_sales), emp_id
FROM works_with GROUP BY emp_id;
the question is: how do i get the output of the name of the employee instead of their emp_id?. We are working on the works_with table but the name is in the employee table.

[PsyChoChiRcuS]

>= '1971-01-01' or > '1970-12-31'

[mohamed.montaser]

you didn't use joins in the last example, how?

[skyblue]

Such a great tutorial!
How to connect emp_id with their name from a different table?

[lilmamagc]

Gonna have to go through this again. I understand somewhat, but I don't understand why it works. :(

[ramzisiliman]

I need more clarification on how to relate tables using SQL

[filibertogarced]

It must be good to work at Dunder Mifflin 😆

[jatindersingh-swip]

Could you make video on lowercase letters and uppercase

[yuanfang]

The code of the last video has the following part:

-- Find all employee's id's and names who were born after 1969
SELECT emp_id, first_name, last_name
FROM employee
WHERE birth_day >= 1970-01-01;

should it be WHERE birth_day >= 1970-01-01; or WHERE birth_day >= '1970-01-01'; (add a single quotes to 1970-01-01) ?

[mohitsinghania]

Guest wants to display Resort Id, Name and Comments of the resort based on it's star rating.
Comments of the resort displays as follows

If rating is between 5.0 to 4.5 then display the comments as 'Excellent Resort'

If rating is between 4.4 to 4.0 then display the comments as 'Very Good Resort'

else display 'Good Resort' . Give alias name to this result as Comments.

Sort the result based on resort id


pls help me with this question and also help me with some tricks.

[ajithc]

How to find which employee sales high and which client buy more??

[zirelyleon]

Hi, I need that the values for a ColumnID, which is a Primary Key, to start at 100 and increment by 5. AUTO_Increment doesn't work in my case because it increases only by 1. How can I do that in MySQL? Hope you could help me. Thanks.

[scottisitt]

7:22 Why did only only four employees show up in the table if there are nine employees from the works_with table?

[africanblood]

On female employees born after 1971 I don't h=think we got the right answer there.