SQL 10 questions Question 1 Write the SQL statement that will display the STUNAM

Question

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

SQL 10 questions

Explanation / Answer

Question 1
select STUNAME, STUMAJOR, STUGPA from STUDENTS

Question 2
select * from Owners

Question 3
select STUNAME, STUGPA from STUDENTS where STUGPA > 3.0

Question 4
select * from STUDENTS

Explanation
Structure of the query to display the columns is given below
select column1, column2, column3 ... from table_name [where condition]
To show all columns, we use * symbol

Note: 4 sub parts at a time please -- Policy of Chegg

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.