Python quizzes: #select

4 quizzes about #select, with an explanation for every answer.

1 SELECT & WHERE Easy Pick the columns you want and keep only the rows that match a condition. SQL · SQL Basics #select#filtering 10 questions · ~5 min Not started Start
2 ORDER BY & LIMIT Easy Sort query results and keep only the first few rows. SQL · SQL Basics #sorting#select 10 questions · ~5 min Not started Start
3 DISTINCT Easy Remove duplicate rows from a result and count unique values. SQL · SQL Basics #select#duplicates 10 questions · ~5 min Not started Start
1 COUNT, SUM, AVG, MIN & MAX Easy Turn many rows into one number with the five core aggregate functions. SQL · Aggregates & GROUP BY #aggregates#select 10 questions · ~5 min Not started Start

Other tags: