Home›Courses›Data Analytics›Section test

Section checkpoint · 05

SQL for Analytics

Use this short test to check whether the main ideas from the section are connected in your mind. A strong score means you can recognise the concepts; revisit linked lessons when an answer feels uncertain.

5questionsTarget: 4/5 or better

Question 11 point

Which concept is most appropriate for this situation: You need SQL to choose columns and filter rows from a table.

Select and WhereGroup by and Aggregate FunctionsCTEs and Readable QueriesInner and Left Join

Question 21 point

Which concept is most appropriate for this situation: You want to package reusable behaviour behind a name and pass values into it explicitly.

Group by and Aggregate FunctionsCase ExpressionsInner and Left JoinSelect and Where

Question 31 point

Which concept is most appropriate for this situation: You need to apply the idea taught in “Case Expressions” and explain how its input is transformed into a valid output.

Group by and Aggregate FunctionsSelect and WhereOrder by and LimitCase Expressions

Question 41 point

Which concept is most appropriate for this situation: You need to combine related records from two tables using one or more shared keys.

Inner and Left JoinGroup by and Aggregate FunctionsCase ExpressionsOrder by and Limit

Question 51 point

Which concept is most appropriate for this situation: You want to break a complex SQL query into named, readable intermediate steps.

Group by and Aggregate FunctionsInner and Left JoinSelect and WhereCTEs and Readable Queries