Скачать с ютуб How to retrieve customer names with their order count ? в хорошем качестве

How to retrieve customer names with their order count ?

CREATE TABLE customers ( customer_id INT PRIMARY KEY, customer_name VARCHAR(50), email VARCHAR(100), phone VARCHAR(20), address VARCHAR(100) ); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1001, 'John Smith', '[email protected]', '1234567890', '123 Main Street'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1002, 'Jane Doe', '[email protected]', '9876543210', '456 Elm Street'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1003, 'David Johnson', '[email protected]', '5555555555', '789 Oak Avenue'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1004, 'Emily Johnson', '[email protected]', '2223334444', '789 Maple Avenue'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1005, 'Michael Brown', '[email protected]', '7778889999', '321 Pine Street'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1006, 'Sarah Wilson', '[email protected]', '1112223333', '567 Cedar Lane'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1007, 'Robert Johnson', '[email protected]', '5554443333', '987 Willow Street'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1008, 'Jennifer Smith', '[email protected]', '9998887777', '456 Birch Avenue'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1009, 'Christopher Davis', '[email protected]', '2221110000', '789 Pine Lane'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1010, 'Olivia Johnson', '[email protected]', '4445556666', '123 Oak Street'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1011, 'Daniel Brown', '[email protected]', '7778889999', '456 Pine Lane'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1012, 'Sophia Wilson', '[email protected]', '1112223333', '789 Elm Avenue'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1013, 'Ethan Anderson', '[email protected]', '5554443333', '987 Cedar Street'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1014, 'Ava Martinez', '[email protected]', '9998887777', '456 Willow Avenue'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1015, 'Liam Thompson', '[email protected]', '2221110000', '789 Birch Lane'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1016, 'Mia Garcia', '[email protected]', '1112223333', '321 Oak Street'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1017, 'Noah Rodriguez', '[email protected]', '4445556666', '654 Elm Lane'); INSERT INTO customers (customer_id, customer_name, email, phone, address) VALUES (1018, 'Isabella Lee', '[email protected]', '7778889999', '987 Pine Avenue'); CREATE TABLE orders ( order_id INT PRIMARY KEY, customer_id INT, order_date DATE, total_amount DECIMAL(10, 2), status VARCHAR(20) ); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (1, 1001, '2023-07-12', 150.50, 'pending'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (2, 1002, '2023-07-11', 250.75, 'shipped'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (3, 1003, '2023-07-10', 75.20, 'delivered'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (4, 1004, '2023-07-09', 99.99, 'pending'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (5, 1001, '2023-07-08', 175.25, 'shipped'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (6, 1003, '2023-07-07', 49.99, 'delivered'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (7, 1002, '2023-06-30', 199.99, 'pending'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (8, 1003, '2023-06-25', 129.50, 'shipped'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (9, 1001, '2023-06-15', 79.99, 'delivered'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (10, 1001, '2023-06-28', 199.99, 'pending'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (11, 1002, '2023-06-20', 299.99, 'shipped'); INSERT INTO orders (order_id, customer_id, order_date, total_amount, status) VALUES (12, 1003, '2023-06-15', 149.99, 'delivered'); Subscribe Now and Stay Updated! 🔔 ► Visit our website: https://visionforanalytics.com/ ► Join our Facebook group:   / 995887284773826