Lesson 9 - MySQL Step By Step: Exercises to practise

In the previous lesson, MySQL Step By Step: More Queries And the M:N Relationship, we learned the M:N relationship, use aliases in JOINs, and we created a new section table. We won't learn anything new today, we're going to practice the knowledge we've gained. We're going to come up with 10 different sample queries.

To learn something, reduce the height of your browser window so that you don't see the resulting query, but just the task description. Try to figure out the query on your own and then check it with the result.

Let's do it!

Examples

Example 1: Select the comments (their content and creation date) in the second quarter of 2012, sorted by date.

The query:

SELECT `content`, `created`
FROM `comment`
WHERE `created` BETWEEN '2012-3-1' AND '2012-6-30'
ORDER BY `created`;

The result:

Great article!          2012-04-06 00:00:00
Good game!              2012-04-06 00:00:00
I died and...           2012-04-14 00:00:00
Great article in deed!  2012-05-06 00:00:00

Example 2:

...End of the preview...
Continue further