NEW
Font size
WorksheetsDatabase Week 3 Quiz
Total questions: 10
Worksheet time: 6mins
Which function would you use to calculate the total revenue from all sales?
COUNT
SUM
AVG
MIN
To analyze sales data by product category, you would use the:
WHERE clause
GROUP BY clause
HAVING clause
ORDER BY clause
If you want to find the average transaction amount for customers who spent more than $1000, you would use the:
WHERE clause
GROUP BY clause
HAVING clause
ORDER BY clause
To calculate the total revenue and the average transaction amount for each product category, you would use:
GROUP BY product_category
GROUP BY product_category, SUM(revenue), AVG(transaction_amount)
SELECT SUM(revenue), AVG(transaction_amount) GROUP BY product_category
SELECT product_category, SUM(revenue), AVG(transaction_amount)
What is the largest country in Africa by land area?
Nigeria
Algeria
South Africa
Democratic Republic of Congo
Who was the first African leader to win the Nobel Peace Prize?
Nelson Mandela
Albert Luthuli
Desmond Tutu
Kofi Annan
Which African country is known for its traditional Kente cloth?
Ghana
Nigeria
South Africa
Kenya
What is the primary economic activity in most African countries?
Manufacturing
Agriculture
Tourism
Mining
Which African country has won the most FIFA World Cup titles?
Cameroon
Nigeria
South Africa
None of the above
Which African animal is known for its long neck?
Zebra
Giraffe
Elephant
Hippopotamus
