Write SQL code that will retrieve patients whose appointment months are the same as with a patient whose patient number ends with 3456 by making use of the LIKE operator. The query must display patientid, patient names, doctor's names and appointment date as detailed in the output. Do not include the patient id ending with 3456 in your output. Your output must resemble the one below. DOCTORNAME PATIENTID Full Name APPOINTTYPE APPOINTDA VAN WYK PJ WAARDT,JOHAN 05/JAN/16 8106070534083 Full medical DE PADIACHY KL 8110102467081 LEWIS,JOHNSON 17/NOV/15 Full medical

Write SQL code that will retrieve patients whose appointment months are the same as with a patient whose patient number ends with 3456 by making use of the LIKE operator. The query must display patientid, patient names, doctor's names and appointment date as detailed in the output. Do not include the patient id ending with 3456 in your output. Your output must resemble the one below. DOCTORNAME PATIENTID Full Name APPOINTTYPE APPOINTDA VAN WYK PJ WAARDT,JOHAN 05/JAN/16 8106070534083 Full medical DE PADIACHY KL 8110102467081 LEWIS,JOHNSON 17/NOV/15 Full medical

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Write the following insert statements. 3. Insert a guest into the table, Guest, using the following…

A: Answer: 3)Performing insert statement: INSERT INTO Guest(guestNo, lastName, firstName, phoneNo,…

Q: Given a database of bike share information write a SELECT statement to retrieve the bike_number,…

A: To execute the SQL queries, firstly we should have a database containing the tables. Later the…

Q: write DQL statement to do the following (and a screenshot of the result): 1. Find cities that exists…

A: SELECT * FROM Customers, Suppliers WHERE Customers.City = Suppliers.City;

Q: Draw finality automata of "(b+aa)*bb".

A: Given:(b+aa)*bb0 or more b or aa's followed by bb(ends with bb)

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: Write the T-SQL scripts for the following tasks: Write a query to list the employees whose email is…

A: SELECT * FROM EMPLOYEES WHERE EMP_MAIL LIKE '%gmail.com';

Q: SQL: Change the salary of those employees in dept 4001, to be 1.5 times their current salary.

A: To write SQL statement to change the salary of those employees in dept 4001, to be 1.5 times their…

Q: Write a JAVA program that will maintain a phone directory using Classes, and Objects. The program…

A: Java code for the above question: The PhoneDirectory class: import java.io.*; public class…

Q: N SQL: For every customer, list the customer number, the customer's entire zip code, and add two…

A: SQL-CREATE TABLE AND INSERT VALUES: BEGIN TRANSACTION; /* Create a table called CUSTOMER */CREATE…

Q: Create a MySQL table named 'prime_test' that contains two columns. The first column is an integer…

A: SQL Query for creating table: CREATE TABLE prime_test { number int NOT NULL, is_prime varchar(50),…

Q: For each band that currently has a female member: Return the name of the band and each artist's…

A: The question has asked us to join three tables, namely, p_artist, p_band, and p_member, based upon…

Q: In SQL Server, specify the differences between the two character data types as follows: NVARCHAR…

A: According to the information given:- We ahev to define the differences between the two character…

Q: with it, paste your code in a text file named Student.txt and save it in your task folder. Write the…

A: This is a SQL question, here first we have to create a table student with a given parameter, then we…

Q: Using php and sql: create a query and any supporting PHP code that will output only messages from…

A: Query: Explain the PHP code which will connect with mysql or any other database and validate the…

Q: T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer…

A: Given : T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer…

Q: CREATE TABLE Fielding( Player CHAR(25), CareerSpan VARCHAR(20), Matches INT, Innings INT, Catches…

A: SQL Query Use inner join to join the 3 tables and get the required result from query

Q: Imagine that you are a database manager at a company that makes custom shirts. One column in the…

A: Create the sample table shirts having columns idshirt as integer and autoincremented, wholesaleprice…

Question

Write SQL code that will retrieve
patients whose appointment months
are the same as with a patient whose
patient number ends with 3456 by
making use of the LIKE operator. The
query must display patientid, patient
names, doctor's names and
appointment date as detailed in the
output. Do not include the patient id
ending with 3456 in your output. Your
output must resemble the one below.
DOCTORNAME
PATIENTID
Full Name
ΑPΡΟINΤΤΥΡE
APPOINTDA
VAN WYK PJ
WAARDT,JOHAN
05/JAN/16
8106070534083
DE
Full medical
PADIACHY KL
8110102467081
Full medical
LEWIS,JOHNSON
17/NOV/15

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

4. Display a list of all book titles and the percentage of markup for each book. The percentageof markup should be displayed as a whole number (that is, multiplied by 100) with nodecimal position, followed by a percent sign (for example, .2793 = 28%). (The percentageof markup should reflect the difference between the retail and cost amounts as a percent ofthe cost.) SQL commands
Write a PL/SQL stored procedure to print number of employees who are working in a job with Title "Tester". Include procedure call also. If the total count of Employees is more than 5 then print "Sufficient number of Employees" If the total count of Employees is less than 5 then print "Insufficient number of Employees" Else print "there are 5 employees". Use Oracle's NO DATA_FOUND build in exception to display the last message. DEPARTMENTS LOCATIONS P DEPARTMENT_ID * DEPARTMENT_NAME MANAGER_ID LOCATION_ID P LOCATION_ID STREET ADDRESS POSTAL_CODE * CITY STATE PROVINCE COUNTRY_ID JOB_HISTORY PF* EMPLOYEE_ID P * START DATE * END DATE F JOB ID F DEPARTMENT_ID EMPLOYEES P EMPLOYEE_ID FIRST NAME * LAST_NAME EMAIL COUNTRIES COUNTRY_ID COUNTRY_NAME F REGION ID PHONE_NUMBER * HIRE DATE F JOB_ID JOBS P JOB_ID * JOB_TITLE MIN_SALARY MAX_SALARY SALARY COMMISSION_PCT MANAGER_ID F REGIONS DEPARTMENT_ID P* REGION_ID REGION_NAME I--
plz fix the following so it runs on sql developper or sql live CREATE TABLE DONORS (donor_id INT NOT NULL,donor_name varchar(255) NOT NULL,donor_age int,PRIMARY KEY (donor_id ),);CREATE TABLE DONATIONS(pledge_id INT NOT NULL,pledge_date varchar(255) NOT NULL,amount_pledged int,Is_paid int,donor_id int,PRIMARY KEY (pledge_id ),FOREIGN KEY (donor_id) REFERENCES DONORS(donor_id));
https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
In SQL code: Create a PL/SQL block to retrieve the name of each employee from the EMPLOYEE table and print the first initial of each name on the screen, incorporating an INDEX BY table.
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
Write the SQL Code for Select the names of wicketkeeper along with the number of sixes that they have hit (while batting) ? table is in the pic
Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
1. Simplify the following logic equation: F = ab'c + abcd' + ab'cd' + acd Also draw the circuit before and after simplifications, and comment on savings on number of gates. % savings (number of gates required before modification – number of gates required with simplest form)* 100/(number of gates required after modification)
Go to the w3schools website’s SQL browser IDE. This is where you canwrite and test your SQL code using their databases. Once you are happywith it, paste your code in a text file named Student.txt and save it in yourtask folder.● Write the SQL code to create a table called Student. The table structure issummarised in the table below (Note that STU_NUM is the primary key):Attribute Name Data TypeSTU_NUM CHAR(6)STU_SNAME VARCHAR(15)STU_FNAME VARCHAR(15)STU_INITIAL CHAR(1)STU_STARTDATE DATECOURSE_CODE CHAR(3)PROJ_NUM INT(2)● After you have created the table in question 1, write the SQL code to enterthe first two rows of the table as below:STU_NUMSTU_SNAMESTU_FNAMESTU_INITIALSTU_STARTDATECOURSE_CODEPROJ_NUM01 Snow John E 05-Apr-14 201 602 Stark Arya C 12-Jul-17 305 11● Assuming all the data in the Student table has been entered as shownbelow, write the SQL code that will list all attributes for a COURSE_CODE of305.…
Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).
When you don’t know the specific value to include in the criteria, you use a ____. a. limited query b. unfilled query c. tagged query d. parameter query