Intermediate Quiz 3
1. How do you select rows where "email" is not NULL?
2. Which SQL statement creates a view named "active_users"?
3. How do you update the salary to 6000 for employee with id=3?
4. Which function returns the length of a string column "name"?
5. How do you delete all rows where "status" is "inactive"?
6. Which SQL statement adds a new column "age" to table "students"?
7. How do you find the maximum value in column "score"?
8. Which SQL clause limits the number of rows returned?
9. How do you select all records except those with "country" = "USA"?
10. Which SQL function returns the sum of a column?
Previous Next