BASIC JOINS exercises

This page lists the 12 exercises about Basic joins in SQL on our website:

Software:	SQL
Topic:	Basic joins
Level:	Relatively easy
Exercise:	Create a query containing a join to list out those films whose source is NA.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Relatively easy
Exercise:	Create a query using the designer, joining 2 tables, then tidy it up and comment its SQL.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Relatively easy
Exercise:	Use an inner join to link two tables together in a query.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Relatively easy
Exercise:	Use the Query Designer in SQL Server Management Studio to join multiple tables in a database of music.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Average difficulty
Exercise:	Create an inner join in a query, then change it to an outer join to show categories having no events.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Average difficulty
Exercise:	Join two tables together in SQL, using alias table names.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Average difficulty
Exercise:	Link the continent, country and event tables with inner joins, and then filter by fields from 2 tables.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Average difficulty
Exercise:	Use basic inner joins to list music albums and their genres before applying filters to the list.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Average difficulty
Exercise:	Use inner joins to link four tables to show Dr Who enemies by author.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Harder than average
Exercise:	Add joins to SQL queries to return values from multiple tables in a database of music.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Harder than average
Exercise:	Use an outer join and criterion to list out the countries which have no corresponding events.

Show this exercise

Software:	SQL
Topic:	Basic joins
Level:	Harder than average
Exercise:	Use inner joins to link lots of tables together, with a WHERE clause.

Show this exercise

You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post