# SQL Exercise: Find the number of matches ended with a result

## SQL soccer Database: Basic Exercise-4 with Solution

**4.** From the following table, write a SQL query to find the number of matches that ended with a result.

*Sample table:* match_mast

**Sample Solution:**

```
SELECT COUNT(*)
FROM match_mast
WHERE results='WIN';
```

Sample Output:

count ------- 40 (1 row)

**Relational Algebra Expression:**

**Relational Algebra Tree:**

## Practice Online

**Sample Database: soccer**

## Query Visualization:

**Duration:**

**Rows:**

**Cost:**

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

**Previous SQL Exercise:** Number of goals in EURO cup 2016 in normal schedule.

**Next SQL Exercise:** Find the number of matches ended with draws.

**What is the difficulty level of this exercise?**

Test your Programming skills with w3resource's quiz.

## SQL: Tips of the Day

**Can a foreign key be NULL and/or duplicate?**

First remember a Foreign key simply requires that the value in that field must exist first in a different table (the parent table). That is all an Foreign key is by definition. Null by definition is not a value. Null means that we do not yet know what the value is.

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

**Exercises: Weekly Top 12 Most Popular Topics**- Pandas DataFrame: Exercises, Practice, Solution
- Conversion Tools
- JavaScript: HTML Form Validation
- SQL Exercises, Practice, Solution - SUBQUERIES
- C Programming Exercises, Practice, Solution : For Loop
- Python Exercises, Practice, Solution
- Python Data Type: List - Exercises, Practice, Solution
- C++ Basic: Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - exercises on Employee Database
- SQL Exercises, Practice, Solution - exercises on Movie Database
- SQL Exercises, Practice, Solution - exercises on Soccer Database
- C Programming Exercises, Practice, Solution : Recursion