Normal 0 false false false EN-US JA AR-SA /* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:””; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:”Cambria”,serif; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin;}1. Use INSTR to find the position of character ‘a’ in the doctor’s name.2. CONCAT the patients’ first and last name and display their DOB in the following format ‘DD, Month YYYY’. Sort the patients’ name alphabetically.PATNAMENEWDOBAllen Mcginnis3, May 1959Anthony Rogers7, December 2041Becky Roach8, September 1975Brian Anderson6, March 2048Chasity Wright23, April 1973Debbie Saillez9, September 1955J.C. Jones17, July 2002Jason Smith12, December 1999Jennifer Poole13, May 2002Joe Sakic16, September 1976John Cochran3, March 2048John Jackson14, October 2043Keith Vanderchuck8, August 1968Lewis Crow16, October 2049Linda Davis17, July 2002Lynn Westra12, July 1957Paul Kowalczyk12, November 1951Paul James14, March 1997Ryan Baily25, December 1977Scott James1, March 2033Stephanie Walters1, January 2045Susan Porter14, November 19673. Write a query to display the doc_name and area as follows. Sort the result according to the doctors’ name.PADDINGBorque_____NeurologyCotner_____NeurologyHarrison__PediatricsJames______NeurologyJames_____OrthopedicLewis_____PediatricsPronger________RehabRobertson_OrthopedicSmith_____Family PraStevenson___DirectorThompson_______RehabVester____Pediatrics4. Display the patients’ new appointment date 3 months from the next appointment date.PAT_NAMENEXTAPPTDATENEW_APPTJames01-JUL-0301-OCT-03Anderson01-JUL-0301-OCT-03James20-JUL-0320-OCT-03Smith15-NOV-0315-FEB-04Porter01-OCT-0301-JAN-04Saillez01-JUL-0301-OCT-03Rogers01-NOV-0301-FEB-04Walters12-DEC-0312-MAR-04Westra02-FEB-0402-MAY-04Poole01-DEC-0301-MAR-04Baily06-JUN-0506-SEP-05Crow01-JUL-0501-OCT-05Cochran02-DEC-0502-MAR-06Roach01-DEC-0501-MAR-06Jackson21-JUL-0321-OCT-03Kowalczyk29-JUL-0329-OCT-03Davis21-JUL-0321-OCT-03Jones21-JUL-0321-OCT-03Wright–Vanderchuck–Mcginnis–Sakic–5. The hospital has decided for each year the doctor has worked, he/she will be given an extra RM1000. Write a query that will calculate the bonus for each doctor according to this requirement. Note: Use Nesting FunctionsDATEHIREDSALPERMONNOOFYRNEW_BONUS05-DEC-9412000263800009-JAN-008100212910021-JAN-9610000253500016-JUN-9811500233450022-JUN-984550232755001-AUG-987950233095002-MAY-959800263580002-MAR-9510500263650018-MAR-976500243050018-DEC-993500212450030-JUN-8916500324850030-JUN-79235004265500
Normal 0 false false false EN-US JA AR-SA /* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-s
INFO 2103 Assignment #2 For this assignment, please use the DOCTOR and PATIENT table. The script is available in both iTaleemC and GC. Script name: hospital.sql/hospital.rtf. Use INSTR to find the position of character ‘a’ in the doctor’s name. CONCAT the patients’ first and last name and display their DOB in the following format ‘DD, Month YYYY’. Sort the patients’ name alphabetically. PATNAME NEWDOB Allen Mcginnis 3, May 1959 Anthony Rogers 7, December 2041 Becky Roach 8, September 1975 Brian Anderson 6, March 2048 Chasity Wright 23, April 1973 Debbie Saillez 9, September 1955 J.C. Jones 17, July 2002 Jason Smith 12, December 1999 Jennifer Poole 13, May 2002 Joe Sakic 16, September 1976 John Cochran 3, March 2048 John Jackson 14, October 2043 Keith Vanderchuck 8, August 1968 Lewis Crow 16, October 2049 Linda Davis 17, July 2002 Lynn Westra 12, July 1957 Paul Kowalczyk 12, November 1951 Paul James 14, March 1997 Ryan Baily 25, December 1977 Scott James 1, March 2033 Stephanie Walters 1, January 2045 Susan Porter 14, November 1967 Write a query to display the doc_name and area as follows. Sort the result according to the doctors’ name. PADDING Borque_____Neurology Cotner_____Neurology Harrison__Pediatrics James______Neurology James_____Orthopedic Lewis_____Pediatrics Pronger________Rehab Robertson_Orthopedic Smith_____Family Pra Stevenson___Director Thompson_______Rehab Vester____Pediatrics Display the patients’ new appointment date 3 months from the next appointment date. PAT_NAME NEXTAPPTDATE NEW_APPT James 01-JUL-03 01-OCT-03 Anderson 01-JUL-03 01-OCT-03 James 20-JUL-03 20-OCT-03 Smith 15-NOV-03 15-FEB-04 Porter 01-OCT-03 01-JAN-04 Saillez 01-JUL-03 01-OCT-03 Rogers 01-NOV-03 01-FEB-04 Walters 12-DEC-03 12-MAR-04 Westra 02-FEB-04 02-MAY-04 Poole 01-DEC-03 01-MAR-04 Baily 06-JUN-05 06-SEP-05 Crow 01-JUL-05 01-OCT-05 Cochran 02-DEC-05 02-MAR-06 Roach 01-DEC-05 01-MAR-06 Jackson 21-JUL-03 21-OCT-03 Kowalczyk 29-JUL-03 29-OCT-03 Davis 21-JUL-03 21-OCT-03 Jones 21-JUL-03 21-OCT-03 Wright – – Vanderchuck – – Mcginnis – – Sakic – – The hospital has decided for each year the doctor has worked, he/she will be given an extra RM1000. Write a query that will calculate the bonus for each doctor according to this requirement. Note: Use Nesting Functions DATEHIRED SALPERMON NOOFYR NEW_BONUS 05-DEC-94 12000 26 38000 09-JAN-00 8100 21 29100 21-JAN-96 10000 25 35000 16-JUN-98 11500 23 34500 22-JUN-98 4550 23 27550 01-AUG-98 7950 23 30950 02-MAY-95 9800 26 35800 02-MAR-95 10500 26 36500 18-MAR-97 6500 24 30500 18-DEC-99 3500 21 24500 30-JUN-89 16500 32 48500 30-JUN-79 23500 42 65500
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.