#5 Meesho SQL Question | Group by Customer
Автор: Corpverse
Загружено: 2026-01-02
Просмотров: 92
CREATE TABLE Customer (
customer_id INT PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(100) NOT NULL,
phone VARCHAR(20)
);
CREATE TABLE Orders (
order_id INT PRIMARY KEY,
customer_id INT,
order_date DATE NOT NULL,
total_amount DECIMAL(10, 2) NOT NULL,
status VARCHAR(20) NOT NULL,
FOREIGN KEY (customer_id) REFERENCES Customer(customer_id)
);
INSERT INTO Customer (customer_id, first_name, last_name, email, phone)
VALUES
(1, 'om', 'kapoor', 'om.k@example.com', '+1234567890'),
(2, 'kiran', 'patil', 'ki.ran@example.com', '+9876543210'),
(3, 'sid', 'jha', 'sid.jha@example.com', '+1112223334'),
(4, 'kiran', 'patil', 'kp@example.com', '+9186042211');
INSERT INTO Orders (order_id, customer_id, order_date, total_amount, status)
VALUES
(1001, 1, '2023-07-01', 1000.00, 'completed'),
(1002, 2, '2023-07-02', 150.50, 'completed'),
(1003, 1, '2023-07-03', 300.25, 'completed'),
(1004, 3, '2023-07-04', 75.80, 'pending'),
(1005, 4, '2023-07-05', 450.00, 'completed');
Connect with us here : https://topmate.io/corpverse
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
