Query operators
Hi, I need help with SQL. I have some errors every time I try run the code. ATTACHMENT PREVIEW Download attachment
![Untitled.jpg](https://coursehero.s3.amazonaws.com/qattachments_e5ac0423bb90731f2c1e85fca6d4a791d88c5cec_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=20190627T223816Z&X-Amz-SignedHeaders=host&X-Amz-Expires=60&X-Amz-Signature=185390261f3ecde8f82a78e2099038b0011d1e405314f08643c7b46882ce10d3)
Untitled.jpg
Query operators A sqi—‘i—4.sq1 file has been created and opened for you. Write the following SQL statement 1. Select all the records from the : ‘lnasic__inFo_ table
Where birthdays are less or equal to 2016 Get the records only ‘rfthe id is between 1 and 5
Order by id in a descending order Complement your SQL’ S’EL’ECT ‘ understanding by writing
the following statements in the sq’1—1’—’8.sq_l ‘file: 1.
2. 3. Use the directory database Select all the co-panyjtot’ilesi records where
conpany_na_l_e is equal to Lore! _Ipsu_l Institute or_ Et
LLP :; Finally, select only the id _and ‘phonngum’ attributes
from the _c_oi11_pany_prof.il._e_s__ table and get the records
where the _id ‘ is between 40 and 60 A sql—‘I—9.5q1 ‘file has been created and opened for you. Write the following query in the _sqi—1—9.5q1 ‘file {write each task in a new line}: 1.
2. Use the; directory database Display the available tables . Select all the records from the colpany_profi1e5 ‘table that match the id: 2? Select only the id and phone_num columns ofthe
company_prolf.iil_.es table and sort them by Ed in
ascending order Select only the id and company_name columns from
the3 company_pr_of:_iles where the id is greater or equal
to 40. lJmit the results to 5 rows.
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)