The statement DESCRIBE workforce; has the following result: name type comment name string occupation string salary int Which is the best statement to get a list of the occupations used in the table?
Question 9
The statement DESCRIBE workforce; has the following result:
name type comment
name string
occupation string
salary int
Which is the best statement to get a list of the occupations used in the table?
1 point
- SELECT salary FROM workforce;
- SELECT DISTINCT salary FROM workforce;
- SELECT occupation, salary DISTINCT FROM workforce;
- SELECT DISTINCT occupation, salary FROM workforce;
- SELECT salary DISTINCT FROM workforce;
- SELECT DISTINCT occupation FROM workforce;
- SELECT occupation FROM workforce;
- SELECT occupation DISTINCT FROM workforce;