Exploring the lab environment - SQL教程

- [Instructor] This course consists of automated code challenges that appear when you click on the challenge links in the course's table of contents. Each challenge includes instructions and a code editor you can use to create and test your own solution to the challenge. These challenges are hosted by CoderPad, and they appear in the same area of the course page where you watch the course's videos. We recommend using a desktop browser for the best experience with code challenges, but you can use the LinkedIn Learning mobile app if you prefer. The code challenge has three areas. Instructions in the top left, a console for output in the bottom left, and a code editor for your answer on the right. You can use these drag handles to reallocate space for the code editor or any other content. To get even more horizontal space for the code editor, you can collapse the course's table of contents on the left. Each challenge has instructions that include a description of the challenge and the challenge's desired result. In this example, the desired result has a single value named price. Create your answer in the code editor. When you click Test my code, you'll see a message indicating whether your code returned a correct result. If you don't see that result immediately, make sure that you've allocated enough space. In this example, I'm seeing incorrect output because I'm querying everything from a particular table in the database. Now, I'm going to change this to the correct answer. I'll use the max function and pass in price and then I'll rename the result price. I'll test the code again and this time I'll see that I got the correct output. If any messages are too long to fit in the console, you can scroll sideways to see all of the text. And when you finished each code challenge, return to the course's table of contents and click the next video to see my solution.