Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started