Multiple choice. Please simply choose the correct answer.

1.To produce a report that includes all Toyotas with a Price value less than $30,000, which WHERE clause would you use?

Make	Model	Price	MPG
Toyota	RAV4	$28,750	23
Honda	Accord	$19,350	32
Honda	Pilot	$32,500	22
BMW	135i	$25,200	24

	a. where Make = "Toyota" and Price < $30,000
	b. where Make = "Toyota" or Price < 30000
	c. where Make = "Toyota" and Price < 30000
	d. where Make = "Toyota" or Price < $30,000

2.You want to count the number of employees in each department and only return the departments with over 30 employees. Which query will produce the correct report?

	a. select Department, count(*) as TotalEmployees from orion.employees where calculated TotalEmployees > 30 group by Department;
	b. select Department, count(*) as TotalEmployees from orion.employees having TotalEmployees > 30 group by Department;
	c. select Department, count(*) as TotalEmployees from orion.employees group by Department having TotalEmployees > 30;

3.Which of the following statements creates a new table named results from a query?

	a. create table results like select ...
	b. create table results as select ...
	c. create table results (select ...)
	d. create table results from select ...

4.Which of the following queries produces a report of all columns from every table in the sashelp library?

a. select * from dictionaries.columns where libname="SASHELP"; b. select * from sashelp.vcolumn where libname="SASHELP"; c. select * from dictionary.columns where libname="SASHELP";