This page has 5 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	SQL (203 exercises)
Topic ==>	Simple Queries (7 exercises)
Level ==>	Relatively easy
Subject ==>	SQL training

Create a query to list out all of the events in the database, with the most recent first

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file . Once you've done this:

Go into SQL Server Management Studio;
Open the SQL file you've just unzipped (you can press CTRL + O to do this); then
Execute this script.

This will generate the database that you'll need to use in order to do this exercise (note that the database and script are only to be used for exercises published on this website, and may not be reused or distributed in any form without the prior written permission of Wise Owl).

Create a query to list out the following columns from the tblEvent table, with the most recent first (for which you'll need to use an ORDER BY clause):

The event name
The event date

You get bonus points for indenting the various parts of your query, and sprinkling it with comments!

Here's what your query should show when you run it:

The first few events - the database stops at the end of 2016.

Save this query as What a way to start.sql, then close it down.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.

You can find other training resources for the subject of this exercise here:

This page has 5 threads

Add a new post

From:	praneeth24
When:	05 Feb 24 at 11:28

select EventName,EventDate from tblEvent

order by EventDate desc

From:	Devender
When:	11 Jan 24 at 14:04

create table table_event(

Name_Event VARCHAR(20) , DATE_OF_EVENT DATE)

insert into table_event(Name_Event , DATE_OF_EVENT)

values('Chess' , '2024-03-26'),

('football' , '2024-01-10'),

('cricket', '2024-02-07'),

('basketball', '2024-04-13'),

('hockey', '2024-03-23');

select * from table_event

order by DATE_OF_EVENT

From:	Rupchand
When:	09 Oct 23 at 18:11

select EventName, EventDate from tblevent order by EventDate desc

From:	wasp
When:	13 Jul 23 at 10:38

select *
from tblEvent

I started with select to see all the columns in the table then i used the other code to answer the question

select eventname,eventdate
from tblEvent
order by eventdate desc

From:	Abdullah53
When:	07 May 23 at 05:49

I just started learning from your website and did my first exercise
below is the query
use WorldEvents
go
select EventName,EventDate
from tblEvent
order by EventDate desc;

Add a new post