Scribd
Upload
4 views1 page

Mis (SQL Question)

The document outlines a series of SQL queries to retrieve and filter data from two tables: Sales and Products. It includes instructions to select specific columns, apply filters based on price and date, and focus on particular categories. The queries aim to extract relevant sales and product information for analysis.

Uploaded by

rishabhvatsrrvv
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

Mis (SQL Question)

The document outlines a series of SQL queries to retrieve and filter data from two tables: Sales and Products. It includes instructions to select specific columns, apply filters based on price and date, and focus on particular categories. The queries aim to extract relevant sales and product information for analysis.

Uploaded by

rishabhvatsrrvv
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

QUESTION:

Consider the database having data in following Tables.


The Sales table records information about product,
including the Sales id, quantity sold, sale date,
and total price for each sale.
The Products table contains details about products,
including their names, categories, and unit prices.

1. Retrieve all columns from the Sales table.


2. Retrieve the sale_id and sale_date from the Sales
table
3. Filter the Sales table to show only sales with a
total_price greater than $100.
4. Retrieve the sale_id and total_price from the Sales
table for sales made on January 3, 2024.
5. Retrieve the product_name and unit_price from the
Products table
6. Filter the Products table to show only products in the
'Electronics' category.
7. Retrieve the product_id and product_name from the
Products table for products with a unit_price greater
than $100

You might also like