Browse All Questions

What does SUM(quantity) return in a GROUP BY query per group?

SQL Data AnalystEasy

Try Now

What does the NOT operator do when combined with IN?

SQL Data AnalystEasy

Try Now

Which SQL clause specifies the table to query data from?

SQL Data AnalystEasy

Try Now

What does UNION do when combining two SELECT statements?

SQL Data AnalystEasy

Try Now

What is a primary key in a relational database?

SQL Data AnalystEasy

Try Now

What does WHERE name LIKE ‘A%’ return?

SQL Data AnalystEasy

Try Now

What does the alias AS keyword do in SQL?

SQL Data AnalystEasy

Try Now

Which function returns the highest value in a column?

SQL Data AnalystEasy

Try Now

What is the result of COUNT(*) on a table with 5 rows where 2 rows have NULL in a column?

SQL Data AnalystEasy

Try Now

What does the IN operator do in a WHERE clause?

SQL Data AnalystEasy

Try Now

Which SQL statement is used to retrieve data from a table?

SQL Data AnalystEasy

Try Now

What does a LEFT JOIN return that an INNER JOIN does not?

SQL Data AnalystEasy

Try Now

Which operator checks if a value falls within a range inclusively?

SQL Data AnalystEasy

Try Now

What is the purpose of GROUP BY in SQL?

SQL Data AnalystEasy

Try Now

What does LIMIT 10 do in a query?

SQL Data AnalystEasy

Try Now

Which wildcard matches any sequence of characters in a LIKE pattern?

SQL Data AnalystEasy

Try Now

What does AVG(salary) return?

SQL Data AnalystEasy

Try Now

Which clause filters groups after aggregation?

SQL Data AnalystEasy

Try Now