SQL 10 questions

Question 1

	Write the SQL statement that will display the STUNAME, STUMAJOR, and STUGPA in the STUDENTS table

Question 2

	Choose the SQL statement that will select all the columns from a table named "Owners"?

Question 3

Write the SQL statement that will display the STUNAME and STUGPA in the STUDENTS table where the STUGPA is greater than 3.0

Question 4

	Write the SQL statement that will display all the columns from the STUDENTS table

Question 5

Examine the table below and write the SQL command that will display all the products from the products table where the price is more than $40

Products

ProductName	Price
TV	$123.44
DVD	$23.00
CDs	$4.00
MP3	$1.00

Question 6

	What SQL command is used to show only different values (no repeats)

Question 7

Take a look at the table below. Write the SQL command that will display all the records from the products table where the price is $23.00

Products

ProductName	Price
TV	$123.44
DVD	$23.00
CDs	$4.00
MP3	$1.00

Question 8

	What SQL command show only those records that fit a specific criteria

Question 9

	Choose the SQL statement that will select all the columns from a table named "Owners"?

Question 10

	Select the SQL command that will find and display data from a table