SQL Practice Set in MS SQL Server

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

4/11 Average production cost of good games

1. Introduction

2. Get to know the Games table

3. Cost-effective games

4. Average production cost of good games

5. Revenue for recent good shooters

6. Game production statistics by year

7. Profitable games by type

8. Gross profit by company

9. Productions statistics

10. Identify good games

11. Congratulations

Cool! Here comes the aggregate function!

Show the average production cost of games that were produced between 2010 and 2015 and were rated higher than 7.

To calculate the average, we need to use the AVG() function.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?