Current Date Orders Query | Dataford Interview Questions

Given customer (c_id, c_name) and product (p_id, p_name) tables, design an orders table and write a query to get product name and customer name of orders on the current date.

Asked in the Round 1 stage.

Output

One row per order placed on the current date.
Return product_name and customer_name.
Sort rows by order_id in ascending order.

Schema

customer

Column	Type	Description
c_idPK	INTEGER	Unique customer identifier
c_name	VARCHAR(100)	Customer name

product

Column	Type	Description
p_idPK	INTEGER	Unique product identifier
p_name	VARCHAR(120)	Product name

orders

Column	Type	Description
order_idPK	INTEGER	Unique order identifier
c_id	INTEGER	Referenced customer identifier
p_id	INTEGER	Referenced product identifier
order_date	DATE	Date on which the order was placed

Your question is Current Date Orders Query. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem