March 4 Activity

2. SELECT book_id, title, author_name, author_address, author_contract, price, advance, royalty, notes, pubdate, pub_id FROM book WHERE title LIKE '%u%';

3. SELECT author_name FROM book WHERE price<600;

4. SELECT title, price FROM book WHERE price<500 AND price>50;

5. INSERT INTO publisher(name, city, state, country) VALUES ('MacLehose Press', '','','United Kingdom');

6. INSERT INTO book (title, author_name, author_address, price, advance, royalty, pubdate, pub_id) VALUES ('The Girl with the Dragon Tattoo', 'Steig Larsson', 'Sweden', 545.00, 150000, 0.15, '20080110', 3);

7. SELECT book_id, title FROM book WHERE price<601;

8. SELECT book_id, title, author_name, author_address, author_contract, price, advance, royalty, notes, pubdate, pub_id FROM book WHERE title LIKE '%A Song of Ice and Fire%' OR title LIKE '%Lord of the Rings%';

9. SELECT DISTINCT author_name FROM book WHERE title LIKE '%Lord of the Rings%' OR title LIKE '%A Song of Ice and Fire%';

10. SELECT book.title 'Title of Book', book.author_name 'Name of Author', publisher.name 'Name of Publisher' FROM book, publisher WHERE book.pub_id = publisher.pub_id ORDER BY publisher.name;

11. SELECT title FROM book ORDER BY title DESC;

12. SELECT DISTINCT author_name 'Author has Name with T' FROM book WHERE author_name LIKE '%T%' OR author_name LIKE '%t%';

13. SELECT book.title, publisher.name FROM book, publisher WHERE book.pub_id = publisher.pub_id AND (author_name LIKE '%T%' OR author_name LIKE '%t%');