Question: For the table data shown below, write a SQL query to fetch the Order_Detail_ID, Product, and Description for the date range 2016-09-16 to 2016-09-01, where

For the table data shown below, write a SQL query to fetch the Order_Detail_ID, Product, and Description for the date range 2016-09-16 to 2016-09-01, where the Role is Owner.

Orders

ID

Order_ID

Status_ID

Order_Detail_ID

State

Note

242

251

4

10259

4

BRL lab

243

252

3

10663

4

244

253

3

10565

3

DNA lab

Accounts

Order_Detail_ID

Type

Account_id

Description

Expiration_Date

243

critical

1096

sample

2016-09-16

244

critical

1026

Sample2

2016-09-01

Users

Account_ID

User_ID

Role

Product

1026

102

Owner

hammer

1096

301

Researcher

axe

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!