SQL 3 – Assignment

PRACTICE QUESTIONS FOR SUB-MODULE 3

Instructions for Practice Questions

To effectively practice SQL joins, use the provided dataset, which includes the following tables:

• Customers (customer details)
• Orders (order transactions)
• Products (electronic product details)

Your Task:

1. Use SQL queries to answer each practice question.
2. Write and execute your SQL code using Microsoft SQL Server or any preferred SQL environment.
3. Ensure your queries retrieve the correct data based on the given scenarios.
4. If needed, modify or expand your queries to explore additional insights.

Reminder: Always reference the dataset structure to correctly use column names in your queries.

Happy Querying! 

QUESTIONS

These questions use the dataset to help learners apply what they’ve learned.

1. Retrieve the first name, last name, and city of all customers who live in Los Angeles.
2. Find all products that cost between $300 and $1000.
3. Retrieve all customers whose email contains “yahoo” anywhere in the address.

EXTRACT THE SCRIPT OF YOUR QUERY AND UPLOAD.