Wyzwanie: Hobby Roberta
INSERT INTO persons (name, age) VALUES ("Ja", 21);
INSERT INTO hobbies (person_id, name) VALUES (5, "tak");

SELECT persons.name, hobbies.name FROM persons JOIN hobbies ON persons.id = hobbies.person_id;

SELECT persons.name, hobbies.name FROM persons
    JOIN hobbies
    ON persons.id = hobbies.person_id
    WHERE persons.name = "Bobby McBobbyFace";

Wyzwanie: Zamówienia klienta
SELECT customers.name, customers.email, orders.item, orders.price
FROM customers
LEFT OUTER JOIN orders ON customers.id = orders.customer_id;


SELECT  name, email, SUM(orders.price)  FROM customers
LEFT OUTER JOIN orders
ON customers.id = orders.customer_id
GROUP BY name
ORDER BY orders.price DESC;
SELECT sequel.title,movies.title
    FROM movies sequel
    LEFT OUTER JOIN movies
    ON sequel.sequel_id = movies.id;
SELECT persons.fullname, hobbies.name FROM persons JOIN hobbies ON persons.id = hobbies.person_id;

SELECT a.fullname, b.fullname FROM friends
    JOIN persons a
    ON friends.person1_id = a.id
    JOIN persons b
    ON friends.person2_id = b.id;
👍
1
<script>document.body.innerHTML = "Inconceivable!";</script>
a w pytaniach
od 1
Document Object Model
document
obiekt
document.body.innerHTML = "Khaaaaan";