SQL code
Hi, Can you help me with SQL code? Please see attached file.
ATTACHMENT PREVIEW Download attachment
![Untitled.png](https://coursehero.s3.amazonaws.com/qattachments_f50a6ff644a231e2482f960dca7f4a956240332e_th.jpg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIAYW2E6VOLDTI35A%2F20190627%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190627T224332Z&X-Amz-SignedHeaders=host&X-Amz-Expires=60&X-Amz-Signature=834372845376260cf20c373f9fad6eaf213468187030431efc751add9df7c337)
Untitled.png
3.4.Chaflenge Selecting table data A 5q1—1—1.5ql file has been created and opened for you. Write each of the following SQL statements in a new line: 1. Listthe available databases
2. Change to the people database 3. List the available tables
4. Select all the records from the basic_inFo table Once you have completed these tasks press the Check ltl button to
have your solution assessed.
Limiting queries A m‘L—i—qul file has been created and opened for you. Write each of the following SQL statements in a new line: 1. Usethe people database 2. Display the name column from the runs table. 3. Display only 3 records of the city column from the basicjnfa
table. Once you have completed these tasks press the Check ltl button to
have your solution assessed. 6.1.Chaflenge Ordering queries
A sq‘l—i-qul file has been created and opened for you.
Write each of the following SQL statements in a new line: 1. Use the people database
2. Display the surname column from the mus table. 3. Query only the name and id oolurnns of the rim: table and
sort the results by id in descending order. Once you have completed these tasks, press the Check It] button to
have your solution assessed.
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
![](https://sp-ao.shortpixel.ai/client/to_webp,q_glossy,ret_img,w_320,h_80/http://academicheroes.com/wp-content/uploads/2018/09/order_now.png)