Database Week 3 Quiz

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