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
Get step-by-step solutions from verified subject matter experts
