SQL Quiz

Which of the following is not a statistical operation keyword in SQL

• AVERAGE

• SUM

• COUNT

• MIN

Which of the following statements are correct(select ALL that apply) to filter sales quantities from 1 to 10

• WHERE SalesQuantity FROM 1 TO 10

• WHERE SalesQuantity BETWEEN 1 AND 10

• WHERE SalesQuantity >1 AND < 10

• WHERE SalesQuantity >=1 AND <=10

Which of the following syntax will allow you find products that contain the word "Medium"

• LIKE '%Medium%'

• LIKE '%Medium'

• LIKE '%Medium%%'

• LIKE 'Medium%'

Which of the following is not a valid type of join

• RIGHT JOIN

• LEFT JOIN

• INTER JOIN

• FULL JOIN

What type of join is represented in the image ?

• LEFT JOIN

• MID JOIN

• RIGHT JOIN

• INNER JOIN

What type of join is represented in the image ?

• RIGHT JOIN

• OUTER JOIN

• LEFT JOIN

• INNER JOIN