Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
What is the correct SQL query to count the number of rows in a table named 'sales' where the 'amount' column exceeds 100?
A
SELECT COUNT_IF(amount > 100) FROM sales;_
B
SELECT COUNT() FROM sales WHERE amount > 100;
C
SELECT COUNT_IF(amount > 100) AS count_above_100 FROM sales;_
D
SELECT COUNT(amount > 100) FROM sales;