Question: Please answer the question as soon as possible . Thank you . CREATE TABLE Customer (Customer No Char(5) NOT NULL, Customer_Name Varchar2(30) NOT NULL, Gender







Please answer the question as soon as possible . Thank you .
CREATE TABLE Customer (Customer No Char(5) NOT NULL, Customer_Name Varchar2(30) NOT NULL, Gender Char(1) NOT NULL, Address Varchar2(60) NOT NULL, Email Address Varchar2(60) NOT NULL, Telephone No Number(10) NOT NULL, No of Clothes Number(2) NOT NULL, Cust. Size Char(5) NOT NULL, Receipt_Date Date NOT NULL, Return Date Date NOT NULL, CONSTRAINT Customer Ne.pk PRIMARY KEY (Customer_No)); CREATE TABLE Designer (Designer_No Char(5) NOT NULL, Designer_Name Varchar2(30) NOT NULL, Address Varchar2(60) NOT NULL, Email Address Varchar2(60) NOT NULL, Telephone_No Number(10) NOT NULL, Social Med Plat Varchar2(30) NOT NULL, Ne Designed Number(3) NOT NULL, Salary Number(4) NOT NULL, CONSTRAINT Designer Newpk PRIMARY KEY (Designer_No)); CREATE TABLE Clothes ( Clothes No Char(5) NOT NULL, Type_Clothes Varchar2(30) NOT NULL, Cond Clothes Varchar2(20) NOT NULL, Type_Fabric Varchar2(20) NOT NULL, Colour Clothes Varchar2(10) NOT NULL, Price Number(3) NOT NULL, Customer No Char(5) NOT NULL, Designer_No Char(5) NOT NULL, CONSTRAINT Clothes No pk PRIMARY KEY (Clothes_No), CONSTRAINT Customer No fk FOREIGN KEY (Customer No) REFERENCES Customer. CONSTRAINT Designer Nefk FOREIGN KEY (Designer_No) REFERENCES Designer); SQL> INSERT INTO Customer 2 (Customer_No, Customer_Name, Gender, Address, Email Address, Telephone_No, No_of_Clothes, Cust_size, Receipt_Date, Return_Date) 3 VALUES 4 ("CU001', 'Sarah', 'F', '163, Main St.', 'sarah365@gmail.com', 0134576232, 2, 'M', TO_DATE('07-05-2021', 'dd-mm-yyyy'), TO_DATE('27-05-2021', 'dd-mm-yyyy')); 1 row created. 2 SQL> INSERT INTO Customer ? (Customer_No, Customer_Name, Gender, Address, Email Address, Telephone_No, No_of_Clothes, Cust_size, Receipt_Date, Return_Date) 3 VALUES 4 ('CU002', 'Ahmed', 'M', '32, Manse Rd.', 'ahmed35@mail.com', 0176158359, 1, 'L', TO_DATE('15-06-2021', 'dd-mm-yyyy'), TO_DATE('05-07-2021', 'dd-mm-yyyy'); 1 row created. SQL> INSERT INTO Customer 2 (Customer_No, Customer_Name, Gender, Address, Email Address, Telephone_No, No_of_Clothes, Cust_size, Receipt_Date, Return_Date) 3 VALUES 4 ("CU003', 'John', 'M', '56, clover Dr', 'johns@mail.com', 0177658349, 3, 's', TO_DATE('04-10-2021', 'dd-mm-yyyy'), TO_DATE('24-10-2021', 'dd-mm-yyyy')); 1 row created. SQL> INSERT INTO Customer 2 (Customer_No, Customer_Name, Gender, Address, Email Address, Telephone_No, No_of_Clothes, Cust_size, Receipt_Date, Return_Date) 3 VALUES 4 ("C1004', 'Susan', 'F', '22, Deer st.', 'sus 3@mail.com', 0114563732, 1, 'XL", TO_DATE('27-12-2021', 'dd-mm-yyyy'), TO_DATE('17-01-2022', 'dd-mm-yyyy'); 1 row created. SQL> INSERT INTO Customer 2 (Customer_No, Customer_Name, Gender, Address, Email Address, Telephone_No, No_of_Clothes, Cust_size, Receipt_Date, Return_Date) 3 VALUES 4 ('CUOOS', 'David', 'M', '6, Lawrence st.', 'dave99@hotmail.com', 0163732343, 5, 'XXL', TO_DATE('13-01-2022', 'dd-mm-yyyy'), TO_DATE( *03-02-2022*, 'dd-mm-yyyy')); 1 row created. SQL> INSERT INTO Designer VALUES ('0001', 'Hannah', '2, Manor Rd.', 'hnnh23@mail.com', 1827456877, 'bannahsdezine', 1999, 99); 1 row created. SQL> INSERT INTO Designer VALUES ('0002', 'Hamid', '8, Holhead st.', 'hmd67@mail.com', 168745397, 'hmmmdesigns', 7000, 230); 1 row created. SQL> INSERT INTO Designer VALUES ('0003', 'Camila', '18, Dale Rd.', 'coco@mail.com', 167788977, 'cocofficial', 5800, 160); 1 row created. SQL> INSERT INTO Designer VALUES ('0004', 'James', '601, W Main St.', 'james80@mail.com', 145668977, jamjamdoes', 2000, 56); 1 row created. SQL> INSERT INTO Designer VALUES ('DO05', 'Mary', '420, N. Santa Anita Street', 'mry29@mail.com', 145979987, 'maryfashion', 4000, 81); 1 row created. SQL> INSERT INTO clothes VALUES ('CLO01', 'Shirt', 'Light', 'Cotton', 'white', 25, 'CU003', 'D002'); 1 row created SQL> INSERT INTO clothes VALUES ('CL002', 'Pants', 'Intermediate', 'Denim', 'Blue', 35, 'Cueol', '0005'); 1 row created. SQL> INSERT INTO Clothes VALUES ('CL003', 'Scarf', 'Light', 'Silk', 'Pink', 15, 'CU004', 'D003'); 1 row created. SQL> INSERT INTO Clothes VALUES ('CL004', 'Skirt', 'Bad', 'velvet', 'Green', 38, 'CU001', 'D001'); 1 row created. SQL> INSERT INTO Clothes VALUES ('CLO05', 'Sweatshirt', 'Intermediate', 'Polyester', 'Black', 30, 'CUOOS', 'D004'); 1 row created. SQL> INSERT INTO Clothes VALUES ('CL006', 'Jacket', 'Light', 'Leather', 'Black', 40, 'CUOO2', '2003'); 1 row created. Query S For customers who received the clothes from June 2021 onwards, show the customers' names and the types of clothes received by the customers. ti r C a
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
