SQL Coding Challenge - May 2020 | Online Practice

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

8/14 Task 3

1. Introduction

2. The cake table

3. The ingredient table

4. The cake_ingredient table

5. The purchase table

Very good!

Mark needs to know the name of the bakery's most expensive cake. Without your SQL skills, Lisa is sunk! Can you help?

Write an SQL query selecting the name of the cake which has the highest price among all cakes.

In WHERE, put a subquery selecting the maximal price among cakes.

Stuck? You'll find out more in this exercise of the SQL Basics course.

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