Search found 21 matches
- Sun Jan 15, 2017 5:15 pm
- Forum: Winter 2017
- Topic: 1a Basic MySQL
- Replies: 11
- Views: 10756
Re: 1a Basic MySQL
Question 1: What are the most checked out books per year? 2: What are the most checked out items per year? Books query: select ye as 'Year', MAX(num) as '# of couts', title, subject.subject, deweyClass, itemtype, subject.bibNumber from (SELECT year(cout) as ye, count(*) as num, title, itemtype, inr...