Can someone please explain how to do these SQL questions?

w Writer Home Insert Page Layout References Review View Section Cloud Sign in - X do Cut Calibri (Body) 12 At A" A Tt AaBbCCD A 41 4 Paste Copy Format B I U . AB * X X2 A - ay - A - A E List Pa. New Style Find and Select Settings Painter Replace W WPS Cloud X Assignment 7(1).docx X + Share Q Find features Assignment 7 Directions: Use SQL Server to create the following queries. Save the queries in as Assignment7.sql. Page | 1 The grading criteria is located in the Assignment 7 box. Use the Sports database for this assignment. E 1. Create a view named PATIENT_SMALL_BALANCE. It consists of the patient number, last name, first name, and zip code for every patient that has a balance less than $1000.00. 2. Create the command using the PATIENT_SMALL_BALANCE VIEW to retrieve the patient last name, zip code and balance where the zip code is in 72379, 72381 and 72512. 3. Create view named THERAPIST_THERAPIES that returns Therapist ID, last name, first name, zip code, therapy code, and description of the therapy. You will need to join three tables, Therapist, Session and Therapies. 4. Create a query on that lists all the records from the THERAPIST_THERAPIES view where the Therapist ID is 'JR085'. 14 Page Num: 1 Page: 1/1 Section: 1/1 SetValue: 3.2in | Row: 9 Column: 81 | Words: 253 |= Spell Check 110% - Type here to search O w m M 9:59 AM 90OF X calls 7/31/2021w Writer Home Insert Page Layout References Review View Section Cloud Sign in - X do Cut Calibri (Body) 12 At A" A It AaBbCCD A A - ay . A . A E List Pa. 41 Paste Copy Format B I U - AB * X X2 New Style Find and Select Settings Painter Replace W WPS Cloud X Assignment 7(1).docx X + Share Q Find features 5. Write but do not execute a command to give John permission to retrieve data from the Patient table. 6. Create a query that allows Sally and Mary the permission to add new Therapies to the Therapies Tables. 7. Users John, Sally and Mary must be able to update the balance in the Patients table. Create a query that gives them permissions. 8. Create an Index on the Session Date field of the Sessions table. 9. Create query to add a foreign key constraint to the PatientNum field in the Sessions Table. 10. Create a query to add a check constraint to the UnitOfTime field in the Therapies table. The UnitOfTime is between 0 and 35. Page Num: 1 Page: 1/1 Section: 1/1 SetValue: 3.2in | Row: 9 Column: 81 | Words: 253 |= Spell Check 110% - + Type here to search O W m M 9:59 AM 90OF X 7/31/2021vSphere - 2630_Student2 - Sumn X 5 2630_Student2 X + X C D A infoadc.mccinfo.net/ui/webconsole.html?vmld=vm-27693vmName=2630_Student2serverGuid=713fd202-2183-4fff-bbd9-47948be... A Update Apps Info1311 Firstnational Lexus LexusEmail TIS Dealer Daily Login Lexus Financial | Le... Reading list 2630 Student2 Enforce US Keyboard Layout View Fullscreen Send Ctrl+ Alt+Delete Assignment7.sql - MSSQL1.Sports (MSSQL1\\Administrator (51))* - Microsoft SQL Server Management Studio (Administrator) Quick Launch (Ctrl+Q) X File Edit View Project Tools Window Help G - 0 1 - 1 - New Query . for one mi . X 1 1 2 - 6-51 -2 * * Sports - Execute . V :: 5 | :" :9 | |37 430: Object Explorer qX Assignment7.sql -..Administrator (51))* # X assignment6.sql -.Administrator (52)) Connect - * ** Y C + description of the therapy. You will need to join three tables, Therapist, Session and Therapies. + 12 + Database Diagrams 13 --4. Create a query on that lists all the records from the THERAPIST_THERAPIES view where the Therapist ID is 'JR085' . Tables 14 + System Tables 15 FileTables 16 --5. Write but do not execute a command to give John permission to retrieve data from the Patient table. External Tables 17 18 + Graph Tables --6. Create a query that allows Sally and Mary the permission to add new Therapies to the Therapies Tables. 100 % dbo.Patient + dbo.Patient_Large_Bala Messages dbo.Session Commands completed successfully. dbo. Therapies + dbo. Therapist Completion time: 2021-07-31109: 54: 43.7951560-05:00 + Views + External Resources 100 % Sunnnums Query executed successfully. MSSQL1 (15.0 RTM) | MSSQL1\\Administrator (51) | Sports | 00:00:00 | 0 rows Ready LO e A 3:09 PM 7/31/2021 3:09 PM Type here to search O w W 90 F X 7/31/2021