数据分析

Question 1

You can use CHARINDEX to find a specific character or pattern within a column. Edit the query to return the CHARINDEX of the string ‘Weather’ whenever it appears within the description column.

Answer 1

Question 2

Having

WHERE is used to filter rows before any grouping occurs. Once you have performed a grouping operation, you may want to further restrict the number of rows returned. This is a job for HAVING. In this exercise, you will modify an existing query to use HAVING, so that only those results with a sum of over 10000 are returned.

Answer 2

Question 3

inner join

Answer 3

Question 4

multiple inner join

Answer 4