SQL exercises on soccer Database: Find the teams played the first match of EURO cup 2016

Last update on May 30 2022 07:30:14 (UTC/GMT +8 hours)

SQL soccer Database: Subqueries Exercise-1 with Solution

1. From the following tables, write a SQL query to find the teams played the first match of EURO cup 2016. Return match number, country name.

Sample table: match_details

Sample table: soccer_country

Sample Solution:

SQL Code:

SELECT match_no,country_name
FROM match_details a, soccer_country b
WHERE a.team_id=b.country_id
AND a.match_no=1;

Sample Output:

 match_no | country_name
----------+--------------
        1 | France
        1 | Romania
(2 rows)

Relational Algebra Expression:

Relational Algebra Tree:

Sample Database: soccer

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: SQL SUBQUERIES Exercises on Soccer Database
Next: From the following tables, write a SQL query to find the winner of EURO cup 2016. Return country name.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

SQL Server SELECT into existing table.

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3