Question

Table: BOOKS
Author_name
Publisher
Book Name
Price
Type
Quantity
001
S
20
650
SUMITA ARORA EPB
THE TEARS WILLIAM HOPKINS FIRST
MY C++
BRAIN
FPB
C++ BRAIN AW.ROSSAINE TDH
THUDERBOLTS ANNA ROBERTS FIRST
COOKERY
FICTION
TEXT
TEXT
FICTION
350
TO2
ROZ
1
]
2
Write the SQL commands:
Create table BOOKS.
To list the names from books of text type.
ni) To display the names and price from books in ascending order of their price
iv)To display the Book Name.
Quantity and Price for all C++ books.
v)To display the Quantity of books where Author name starts with "A**
To display the Book_Name where Price>350.
vii) To display the Book Name where `MI is a substring in Author Name.
Give the Output of the following commands:
visi;Select Book_Name Price from Books where type="Text":
b) Select DISTINCT Publishers from Books where Price>700;
2
2
1
1​

Answer 1

Answer:

Please send in correctly

Explanation:

Please mark me as brilliant