- SELECT SUM(pages)
- FROM books;
- SELECT SUM(released_year) FROM books;
- SELECT author_fname,
- author_lname,
- Sum(pages)
- FROM books
- GROUP BY
- author_lname,
- author_fname;
- SELECT author_fname,
- author_lname,
- Sum(released_year)
- FROM books
- GROUP BY
- author_lname,
- author_fname;
Saturday, February 22, 2020
Subscribe to:
Post Comments (Atom)
Right Joins
-- OUR FIRST RIGHT JOIN (seems the same as a left join?) SELECT * FROM customers RIGHT JOIN orders ON customers.id = orders.custom...
-
CODE: Primary Keys Define a table with a PRIMARY KEY constraint: CREATE TABLE unique_cats ( cat_id INT NOT NULL , name ...
-
CODE: Setting Default Values Define a table with a DEFAULT name specified: CREATE TABLE cats3 ( name VARCHAR ( 20 ) DEFAUL...
-
SELECT MIN ( released_year ) FROM books ; SELECT MIN ( released_year ) FROM books ; SELECT MIN ( pages ) FROM books ; SELE...
No comments:
Post a Comment