1) To find the total number of streams by date, you can use the SQL `GROUP BY` clause. Here is the SQL query:

```sql
SELECT date, SUM(number_of_streams)
FROM movie_streaming
GROUP BY date;
```

2) To find the total number of streams by date and director, you can extend the previous query to include the director in the `GROUP BY` clause:

```sql
SELECT date, director, SUM(number_of_streams)
FROM movie_streaming
GROUP BY date, director;
```

3) To find the total number of streams by date and director, but only show dates with a total number of streams above 740, you can add a `HAVING` clause to the previous query:

```sql
SELECT date, director, SUM(number_of_streams)
FROM movie_streaming
GROUP BY date, director
HAVING SUM(number_of_streams) 740;
```

The `HAVING` clause is used in SQL to filter the results of a `GROUP BY` clause, similar to how the `WHERE` clause is used to filter the results of a `SELECT` statement.

Question

1) To find the total number of streams by date, you can use the SQL `GROUP BY` clause. Here is the SQL query:

```sql
SELECT date, SUM(number_of_streams) 
FROM movie_streaming 
GROUP BY date;
```

2) To find the total number of streams by date and director, you can extend the previous query to include the director in the `GROUP BY` clause:

```sql
SELECT date, director, SUM(number_of_streams) 
FROM movie_streaming 
GROUP BY date, director;
```

3) To find the total number of streams by date and director, but only show dates with a total number of streams above 740, you can add a `HAVING` clause to the previous query:

```sql
SELECT date, director, SUM(number_of_streams) 
FROM movie_streaming 
GROUP BY date, director
HAVING SUM(number_of_streams) > 740;
```

The `HAVING` clause is used in SQL to filter the results of a `GROUP BY` clause, similar to how the `WHERE` clause is used to filter the results of a `SELECT` statement.

Knowee AI · Accepted Answer

1) To find the total number of streams by date, you can use the SQL `GROUP BY` clause. Here is the SQL query:

```sql
SELECT date, SUM(number_of_streams) 
FROM movie_streaming 
GROUP BY date;
```

2) To find the total number of streams by date and director, you can extend the previous query to include the director in the `GROUP BY` clause:

```sql
SELECT date, director, SUM(number_of_streams) 
FROM movie_streaming 
GROUP BY date, director;
```

3) To find the total number of streams by date and director, but only show dates with a total number of streams above 740, you can add a `HAVING` clause to the previous query:

```sql
SELECT date, director, SUM(number_of_streams) 
FROM movie_streaming 
GROUP BY date, director
HAVING SUM(number_of_streams) > 740;
```

The `HAVING` clause is used in SQL to filter the results of a `GROUP BY` clause, similar to how the `WHERE` clause is used to filter the results of a `SELECT` statement.

We have following relationmovie_streaming(id,date,movie,director,number_of_streams)1) Find the total number of streams by date.2) Find the total number of streams by date and director.3) Find the total number of streams by date and director. Show only dates with a totalnumber of streams above 740

Question

Solution

Similar Questions

Upgrade your grade with Knowee