Retrieve Order Details from Northwind for February 26, 2018
Medium
3
77.8% Acceptance
In this lab, you'll be working with a sample database. Your main focus will be on the orders
table.
Task:
Retrieve the order_date
, shipped_date
, customer_id
, and freight
for all orders placed on 2018-02-26
.
Key Concepts:
- SELECT Clause: Used to specify the columns you want to retrieve in your result set.
- FROM Clause: Specifies the table from which you want to fetch the data.
- WHERE Clause: Used to filter the records based on a specific condition.
Ensure your query fetches the correct columns and filters the data accurately based on the date specified. Once you're confident in your solution, execute the query to retrieve the desired data.
Good luck!