Question
What is the total number of all pizzas sold in the first
two weeks? Study the pie chart carefully and answer the following questions given below: The bar graph shows the three different types of pizzas sold by Pizza Hut in four different weeks.Solution
Total number of all pizzas sold in the first two weeks = (150 + 100 + 200) + (130 + 150 + 100) = 830
Which command removes all rows but keeps table structure?
Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
Which of the following SQL constructs avoids returning duplicate rows?
Which SQL clause is used for filtering rows?
Which SQL keyword removes duplicate rows automatically from results?
Which operator is used to combine results of two SELECT queries and remove duplicates?
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
Which operator is used for pattern matching in SQL?
Which SQL clause is used to filter records based on aggregate functions?
Which SQL clause is used to group rows?
Relevant for Exams:
