Get up to 60 % extra points for free! More info

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

You will gain knowledge worth hundreds of thousands for a few crowns

You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.

Limited offer: Learn all knowledge and save money

Buy lessons and exercise submitting one by one 50 points
Buy all currently available lessons with exercise submitting and other features for an exclusive price 43 points ($3.87)
Currently, you have 0 points
By buying this exclusive package, you'll have access to all 13 lessons in this course including exercise submitting while saving $0.63. This offer is limited for the first lessons only with an additional exclusive 15% discount.
You gain 43 points for adding an article to the site, or for $4.50 $3.87

Warning, by buying just this lesson you'll lose the limited 15% discount for the package of all the lessons.

Buy only the lesson 10 points
Currently, you have 0 points
You gain 10 points for adding an article to the site, or for $0.90

Before buying this article, you have to buy the previous one

This article is licensed: Premium, by buying this article, you agree with the terms of use.

What will you get from us in the next lessons?
  • Unlimited and permanent access to individual lessons.
  • High quality IT knowledge.
  • Skills to help you get your dream and well-paid job.

Article description

Requested article covers this content:

In this tutorial, we'll give you several exercises you can try to run on a MySQL database to practice and check the results with yours.

You gain points by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.

Article has been written for you by David Capka
Avatar
The author is a programmer, who likes web technologies and being the lead/chief article writer at ICT.social. He shares his knowledge with the community and is always looking to improve. He believes that anyone can do what they set their mind to.
Unicorn university David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.
Activities (6)