SQL exercises on soccer Database: Find the number of booking happened in extra time

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

SQL soccer Database: Exercise-29 with Solution

29. From the following table, write a SQL query to count the number of booking happened in extra time.

Sample table: player_booked

Sample Solution:

SQL Code:

SELECT COUNT(*)
FROM player_booked
WHERE play_schedule='ET';

Sample Output:

 count
-------
     7
(1 row)

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: From the following table, write a SQL query to count the number of booking happened in stoppage time.
Next: SQL SUBQUERIES Exercises on Soccer Database

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

Nested select statement in SQL Server.

You need to alias the subquery.

SELECT name FROM (SELECT name FROM agentinformation) a

or to be more explicit

SELECT a.name FROM (SELECT name FROM agentinformation) a

Database: SQL Server

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