SQL Data Analyst

What does the following window function return for each row? SUM(sales) OVER (PARTITION BY region ORDER BY sale_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

SQL Data AnalystMedium

Try Now

Which window function divides rows into 4 approximately equal groups?

SQL Data AnalystMedium

Try Now

What is the difference between ROW_NUMBER() and RANK() when there are tied values?

SQL Data AnalystMedium

Try Now

What does UNION ALL do differently from UNION?

SQL Data AnalystEasy

Try Now

What does MIN(price) return?

SQL Data AnalystEasy

Try Now

What is the correct SQL clause execution order for a standard SELECT query?

SQL Data AnalystEasy

Try Now

Which SQL keyword retrieves all columns from a table?

SQL Data AnalystEasy

Try Now

What does a foreign key enforce in a relational database?

SQL Data AnalystEasy

Try Now

What does WHERE salary BETWEEN 50000 AND 80000 include?

SQL Data AnalystEasy

Try Now

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

SQL Data AnalystEasy

Try Now

Which SQL clause specifies the table to query data from?

SQL Data AnalystEasy

Try Now

What does the NOT operator do when combined with IN?

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 the alias AS keyword do in SQL?

SQL Data AnalystEasy

Try Now

What does WHERE name LIKE ‘A%’ return?

SQL Data AnalystEasy

Try Now

Which function returns the highest value in a column?

SQL Data AnalystEasy

Try Now

What does the IN operator do in a WHERE clause?

SQL Data AnalystEasy

Try Now