In MySQL 1. Take a look at the table below. Write the SQL command that will disp
ID: 3749192 • Letter: I
Question
In MySQL
1.
Take a look at the table below. Write the SQL command that will display all the records from the products table in alphabetical (A-Z) order based on the ProductName.
Products
ProductName
Price
TV
$123.44
DVD
$23.00
CDs
$4.00
MP3
$1.00
2.
Write the SQL statement that will display the STUNAME and STUGPA in the STUDENTS table where the STUGPA is greater than 3.0
3. Write the SQL statement that will display the STUNAME, STUMAJOR, and STUGPA in the STUDENTS table
4.
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
5. 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
6.
Take a look at the table below. Write the SQL command that will display all the records from the products table in alphabetical (A-Z) order based on the ProductName.
Products
ProductName
Price
TV
$123.44
DVD
$23.00
CDs
$4.00
MP3
$1.00
7.
Write the SQL statement that will display the STUNAME and STUGPA in the STUDENTS table. The output is ordered by the STUNAME
8.
Take a look at the table below. Write the SQL command that will display all the records from the products table where the product names is DVD or the price is $4.00
Products
ProductName
Price
TV
$123.44
DVD
$23.00
CDs
$4.00
MP3
$1.00
9.
Take a look at the table below. Write the SQL command that will display all the records from the products table in reverse alphabetical (Z-A) order based on the ProductName.
Products
ProductName
Price
TV
$123.44
DVD
$23.00
CDs
$4.00
MP3
$1.00
1.
Take a look at the table below. Write the SQL command that will display all the records from the products table in alphabetical (A-Z) order based on the ProductName.
Products
ProductName
Price
TV
$123.44
DVD
$23.00
CDs
$4.00
MP3
$1.00
Explanation / Answer
1.
Select * from Products order by ProductName;
2.
Select STUNAME , STUGPA from STUDENTS where STUGPA > 3;
3.
Select STUNAME, STUMAJOR, STUGPA from STUDENTS;
4.
Select * from Products where Price>' $40';
5.
Select * from Products where Price = '$23.00';
6.
Select * from Products order by ProductName;
7.
Select STUNAME , STUGPA from STUDENTS order by STUNAME;
8.
Select * from Products table where ProductName = 'DVD' or price = '$4.00';
9.
Select * from Products order by ProductName desc;
Do ask if any doubt. Please upvote.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.