1. Engineering
  2. Computer Science
  3. 1 why would you use a group by clause in...

Question: 1 why would you use a group by clause in...

Question details
1. Why would you use a GROUP BY clause in a SELECT statement? 2. Explain the difference between SELECT launch_dt, MAX(price) GROUP BY launch_dt ORDER BY launch_dt; And SELECT launch_dt, MAX(price) ORDER BY launch_dt; 3. Why would you use the HAVING clause in a SELECT statement? 4. What is the difference between a primary key and a foreign key in SQL? 5. Why would you join tables? What is the difference between inner join and an outer join? Explain using examples 6. Present next week your final project with the list of all tables and columns 7. Next week – we start with a short quiz
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution