Display order_id, customer_id from order_db whose month of delivery is the current month.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

The class I'm taking is databass management in computer science!

I have attached the problem below! Please view both attachments before answering. one attachment is the table and its contents and the other attachment is the question i need help finding a solution for. I am using mysql terminal. Please explain in detail so i can fully understand . Thank you so much in advance!

mysql> alter table order_db drop column status;
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show create table order_db;
| Table | Create Table
| order_db | CREATE TABLE 'order_db' (
`orderid` int DEFAULT NULL,
'custid` int DEFAULT NULL,
'itemcode ` int DEFAULT NULL,
`orderquantity' int DEFAULT NULL,
`deliverydate`date DEFAULT NULL,
`modeofpayment` char(1) DEFAULT NULL,
`date_of_order' date DEFAULT NULL,
UNIQUE KEY `uc_order_id` (`orderid`),
KEY `fk_customer' ('custid`),
CONSTRAINT `fk_customer' FOREIGN KEY (`custid`) REFERENCES `customer_db` (`cust_id`),
CONSTRAINT `chk_mode_of_payment` CHECK ((`modeofpayment` in (_utf8mb4'D', _utf8mb4'R',_utf8mb4'C')))
> ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
1 row in set (0.00 sec)
‒‒‒‒‒‒‒‒‒‒‒‒
Transcribed Image Text:mysql> alter table order_db drop column status; Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show create table order_db; | Table | Create Table | order_db | CREATE TABLE 'order_db' ( `orderid` int DEFAULT NULL, 'custid` int DEFAULT NULL, 'itemcode ` int DEFAULT NULL, `orderquantity' int DEFAULT NULL, `deliverydate`date DEFAULT NULL, `modeofpayment` char(1) DEFAULT NULL, `date_of_order' date DEFAULT NULL, UNIQUE KEY `uc_order_id` (`orderid`), KEY `fk_customer' ('custid`), CONSTRAINT `fk_customer' FOREIGN KEY (`custid`) REFERENCES `customer_db` (`cust_id`), CONSTRAINT `chk_mode_of_payment` CHECK ((`modeofpayment` in (_utf8mb4'D', _utf8mb4'R',_utf8mb4'C'))) > ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | 1 row in set (0.00 sec) ‒‒‒‒‒‒‒‒‒‒‒‒
Display order_id, customer_id from order_db whose month of delivery is the
current month.
Transcribed Image Text:Display order_id, customer_id from order_db whose month of delivery is the current month.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education