3-Advanced SQL | Learn Subqueries In SQL| Subquery in From clause [Arabic] part3 скачать в хорошем качестве

3-Advanced SQL | Learn Subqueries In SQL| Subquery in From clause [Arabic] part3

Learn Subquery in From clause Code of Updated database ---------------------------------------------------- /* new insert some new values*/ -- Step 1: Add the Author INSERT INTO Authors( author_id, author_name) VALUES (4, 'Brandon Sanderson'), -- Will have a $60 book (5, 'Agatha Christie'), -- Will have a $15 book (6, 'Ernest Hemingway'),-- Authors with "No Books" (7, 'Andy Weir'), -- Will have a $70 book (8, 'Neal Stephenson'), (9, 'Oscar Wilde'); INSERT INTO Books(book_id, title, Price, author_id) VALUES (106, 'The Way of Kings', 60.00, 4), (107, 'Murder on the Orient Express', 15.00, 5), (108, 'Project Hail Mary', 70.00, 7), (109, 'Snow Crash', 65.00, 8), -- Neal Stephenson (110, 'The Picture of Dorian Gray', 12.50, 9); -- Oscar Wilde -- 3. Sales Table (The Transactions) CREATE TABLE Sales ( Sale_ID INT PRIMARY KEY, book_id INT, Quantity INT, SaleDate DATE, FOREIGN KEY (book_id) REFERENCES Books(book_id) ); INSERT INTO Sales (Sale_ID, book_id, Quantity, SaleDate) VALUES -- Original Books (501, 101, 5, '2026-01-01'), -- Rowling ($100 total) (502, 102, 2, '2026-01-02'), -- Rowling ($110 total - Luxury) (503, 103, 10, '2026-01-03'), -- Martin ($150 total) (504, 104, 4, '2026-01-04'), -- King ($48 total) (505, 106, 3, '2026-01-15'), -- Sanderson ($180 total) (506, 107, 10, '2026-01-16'), -- Christie ($150 total) (507, 108, 5, '2026-01-17'), -- Weir ($350 total - Luxury) (508, 109, 2, '2026-01-18'), -- Stephenson ($130 total - Luxury) (509, 110, 20, '2026-01-19'); -- Wilde ($250 total)