Question

1.Create a table "Stationed" having fields -
ProductNname
ProductDealer
DealerId
Stock
Sales
Price

2. Insert 4 records in Above table.

3. Display all records

4. Display records of product name, stock

5. Display records of delar name and sales.

6. Display all records whose price is 50.

7. Display all records whose price is less then 100.

8. Display product name, sales whose price is more than 75

9. Display all records whose product name is pen.

10. Display all records whose sales is less than 500




Plz create the queries on the pages and upload!

Answer 1

1. Creαte tαble Stationed(ProductName vαrchαr(20), ProductDealer vαrchαr(20), DealerId int, Stock int, Sales int, Price int);

2.

• Insert into Stationed values('Book', 'Maped', 456, 12, 550, 50);
• Insert into Stationed values('Ruler', 'Cosmo', 877, 25, 700, 45);
• Insert into Stationed values('Sharpener', 'Camile', 521, 14, 230, 87);
• Insert into Stationed values('Envelope', 'Arem', 211, 50, 84, 12);

3. Select * from Stationed;

4. Select ProductName, Stock from Stationed;

5.  Select ProductDealer, Sales from Stationed;

6. Select * from Stationed where Price = 50;

7. Select * from Stationed where Price < 100;

8. Select ProductName, Sales from Stationed where Price > 75;

9. Select * from Stationed where ProductName = 'Pen';

10. Select * from Stationed where Sales < 500;