Doctor id Doctor_name Degree Join year Salary D550 Saleh Khalil DM 2001 1700 D551 Osama Ahmad DPM 2011 2100 D552 Sarah Qasim B.Med 2013 1500 D553 Zuhair Mohammad DOM 2008 1600 D554 Amera Jalal MBBS 2006 1000 1.Show the doctor name and the degree IN the following format. Example Saleh Khalil is DM Doctor
Q: CONCAT the patients’ first and last name and display their DOB in the following format ‘DD, Month…
A: According to a question we need to CONCAT the patients’ first and last name and display their DOB in…
Q: From worksheet Laptop, in cell 15, find the category if 600 < Price <=D1030 then Category is "C1"…
A: Hey there, I am writing the required solution based on the above given question. Please do find the…
Q: Consider the following table then answer the following questions? Stld StNameCourseName Courseld…
A: Yes the above given table is in 1NF or first normal form. It states that all the values in the…
Q: employeeAbsences.bxt # × daysOut.cpp EMPLOYEE ABSENCE REPORT employee id 1234 days absent 3 22 667 4…
A: C++ code :- #include <iostream> using namespace std; int main() { string id; int…
Q: Your Name - Week 1 PA Classes Initial information for each employee Name: John Jones Monthly Salary:…
A: As per the requirement program is developed in java. Algorithm: Step 1: Write the Employee class…
Q: Create the following table with the following structure Doctors: Column Name Doctor id Doctor_name…
A: According to the Question below the Complete Query
Q: Table EMP Column name EMPNO ENAME Column type Integer Up to 10 characters Example entry 7369…
A: Given: - The solution as per the given information
Q: Based on the ERD below, display Employee first name, middle initial and last name so it displays in…
A: In this case, the whole name is displayed in a single column of employees where the job code is…
Q: Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh…
A: DOCTOR TABLE: CREATE TABLE DOCTOR(Docotr_id varchar2(5),Doctor_name varchar2(25),Degree…
Q: Display the manager number and the salary of the lowest paid employee for that manager. Exclude…
A: We will write SQL query to solve the given problem.
Q: 4. Display customer ID, customer name, and the order ID and the order date of all orders for…
A: 4) SELECT c.CUSTOMER_ID, c.NAME, o.ORDER_ID, o.ORDER_DATE, oi.QUANTITY AS "Total Items",…
Q: Using a SET operator, Display all names that are used both as a last name and a first name. Example:…
A: SET operators are special type of operators which are used to combine the result of two queries.…
Q: Person(Name, Age, Phone, Extension) Find all names whose Extension starts with 5 folllowed by any…
A: we want it to start from 5, have exactly one character in the second place, which is denoted by the…
Q: Complete the following exercise: Alter your student table adding a new column called enroll_date…
A: Alter your student table adding a new column called enroll_date using the datetime data type.…
Q: The pg2.np_2016traffic table contains monthly traffic statistics from the National Park Service for…
A: Given : we have to create a new table which will contain monthly traffic statistics with park names.…
Q: Create a series called 'directors' that contains each director's name and his or her average rating.…
A: #include<bits/stdc++.h> using namespace std; Struct director( string name; int rating; } int…
Q: US gun murders by state for 2010 Description: Gun murder data from FBI reports. Also contains the…
A:
Q: Find the first names and last names of employees if they got a salary increase more
A: create table commands and inserting sample data into the table for query create table employees…
Q: ISKier the SALEMAD NAME MUMERIC (8) WICHAR) wCHAR (16 DECMALD aSTOMERD MERC(S) CUT NAE CHR ( CITY…
A: The required query is given in step 2.
Q: Column Name Sie Constraints Data Type DepelD Varchar 4 Primary key DepeName 40 Not mull Varchar…
A: I have created the query below for the table:
Q: The following query throws an error. Choose the correct reason for the error as given in the options…
A: Here B and C both part are correct R square always increase with increase in number of variable…
Q: EMP NO EMP NAME | EMP COMM DEPTNO | DEPT NAME | MIN SAL | MAX SAL | DEPTNO EMP EMP SAL | DEPTNO |…
A: /* Creation of EMP table, I am creating column EMP_FIRST_NAME and EMP_LAST_NAME instead of…
Q: Question 2: implement get_athletes() function and return a list of athletes * Requirement: the…
A: Answer: MySQL Source Code: CREATE TABLE athletes( id int not null PRIMARY KEY AUTO_INCREMENT,…
Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…
A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…
Q: paid salesperson for 10 months. The following are the monthly paychecks in $: 3000, 3300,
A: THE CODE IS IN BELOW STEP
Q: epartment DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo…
A: required: Function which takes input data (RollNo, Sname, Fname and DepartmentID) of student from…
Q: 15. List the first name for all contacts and whether they have a spouse or not (yes/no). Order by…
A: Structured Query Language : SQL ( Structured Query Language) is an area explicit language utilized…
Q: The following table stores details of tutors, students and dates of lectures. The Primary Key is…
A: Rules regarding 2nd NF:- tables must be in 1st NF. No non-prime is functionally dependent on part…
Q: There's a "messages" table that has more than 1 million rows of information about the messages that…
A: Given Data : Table name : messages Table attributes : message_id from_user_id to_user_id…
Q: Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh…
A: 4. Show the doctor's names, degree and salary for all doctors who hoint between 2010 and 2015 select…
Q: Department DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo Sname…
A: Actually, given information: Department DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS…
Q: The file P02_02.xlsx contains data on 256 movies that grossed at least $1 million in 2017. • Recode…
A: The table containing data about 211 movies released is given below.
Q: 5. Display the employee name and department number of all employees in departments 10 and 30 in…
A: Before writing the query for the given condition we have to create the table and then we have to…
Q: I. Which normal form is the following table in? I. Transfer the table to 3rd Normalised form and…
A: Primary key is (agreementID, BuildingID) The FDs are AgreementID -> Duration UnitID ->…
Q: Objective: At the end of the exercise, the students should be able to: Use arithmetic operators and…
A: Given student course table for we have to create table and insert data and write the queries using…
Q: 1. Using Printf , \t & \n and get the ouput as shown below *** **** **** CIMS Student Result Report…
A: Sample Response: //C programming language#include <stdio.h>//main function definitionint…
Q: Create a function that calculate the total commission
A: The solution is written in SQL query. Please check step 2 for the solution.
Q: Subject SubjectNO Student SUB_Name STD_Name Pre SUB STD NO Registration SubjectNO STD NO REG date…
A: A procedure in SQL is a reusable unit that encapsulates the specific business logic of the…
Q: Display all the student names whose grade is C. Display the Section-Identifier and Course-name…
A: The answer is
Q: TABLE FOR EMPLOYEE SALARY EMP ID EMP NAME TOTAL SALARY TAX1 TAX2 NET SALARY notes 1 TAYSEER 850 tax1…
A: The given problem is to be solved in Excel using suitable formulas to find the output value for each…
Q: The following statement uses a non-correlated subquery to find the South American country with the…
A: Question 1. The following statement uses a non-correlated subquery to find the South American…
Q: The Movie table has the following columns: ID - integer, primary key Title - variable-length string…
A: The query along with a screenshot of the output is given below.
Q: Based on given data sets (car_final.csv and car_insurance.CSV), complete the following tasks:
A: As mentioned the question the datasets are : --> car_final.csv --> car_insurance.csv a) Code…
Q: Customer ID 1 2 3 4 5 6 7 8 9 10 Items of transaction {A,B,E,D} {A,C,D,E} {D,E,A} {E,B,A,C}…
A: please do upvote for my efforts ! answer:
Q: Select "Patent Number Search" for patents. Give the title or brief description for each of the…
A: Question = Select "Patent Number Search" for patents. Give the title or brief description for each…
Q: Use the Histogram tool to construct frequency distributions and histograms for weekly usage and…
A: 1) Histogram for Weekly usage
Q: V M.Code Module B M_Code M_Name M_Credit M_Duration Write SQL statements for the following: 6.1…
A: please do upvote for my efforts thanks! anwer: 6.1) CREATE TABLE Students( S_ID int…
Q: 18. The HR department needs a report of employees in Toronto. Display the last ame, job, de ment…
A: We are supposed to solve only question, please repost other question. The query is written for…
Q: The sold products names for each date should be sorted lexicographically. Return the result table…
A: Create Activities table: CREATE TABLE Activities(sell_date date,product varchar(50));…
Step by step
Solved in 3 steps with 1 images
- MySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.MYSQL Create a view vTop_Course_count to list the top 2 most popular course names and the number of students took these two courses for all years. Below is a sample output. | name mycount Java2 Data Structure 10 Students sid first_name last_name birthday major zipcode Huang 1990-01-01 cs 1976-02-08 IT 1987-03-21 Math 1947-08-25 Biology 07101 1997-01-25 | CS 1995-09-15 IT 1988-01-15 |Nursing |07101 |07123 08348 1001 Austin 1002 Mary Smith 1003 Claudia Lee 91384 1004 Andrew Lin 1005 Helen Wu 07083 1007 1008 Sarah Lee 4101 Andrew |Huang Courses cid name credits CPS1231 |Java1 14 CPS2231 Java2 CPS2232 Data Structure CPS3500 Web Programming CPS3740 Database Introduction 3 CPS5740 Database Systems CPS5921 Data Mining 4 4 3 3 Students_Courses sid cid year semester grade CPS2231 2013 CPS2231 2015 CPS2231 2014 CPS3740 2011 CPS2232 2014 CPS2232 2016 1001 Fall A- 1003 Spring Spring A- 1004 1009 Fall B- 1009 Fall 1001 1004 Fall C+ CPS2232 2014 Spring B+
- SQL: Create a SQL query that uses an uncorrelated subquery and no joins to display the descriptions for products provided by a vendor in area code 615. Remember, the main difference between a correlated subquery and uncorrelated subquery is that, in a correlated subquery, the inner query is dependent upon the outer query, while, with an uncorrelated query, the inner query does not depend upon the outer query. Instead, it runs just once. You should NOT use union, minus, or intersect in this query. The outer query will use the PRODUCT table and the inner query will use the VENDOR table [hint: you should have 9 records of output]. My code: select p_descript from product where (select v_areacode from vendor where v_areacode = '615' ; I am getting this error, problem is I can't see what is missing any assistance is appreciated. ORA-00936: missing expressionMySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh Khalil DM 2001 1700 D551 Osama Ahmad DPM 2011 2100 D552 Sarah Qasim B.Med 2013 1500 D553 Zuhair Mohammad DOM 2008 1600 D554 Amera Jalal MBBS 2006 1000 5. Show the doctor names, degree and salary who is degree is DM or DPM or DOM sort the output based on mes in the alphabetical order. the doctor
- Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438? 3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4. Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?Apex, Salesforce In which you have two types of Record type on Position Object one is for Technical and one is non technical Record type. you have to write a SOQL query to fetch All the reocrd type of the ID of Technical Record Type. Please Run the SOQL Query on the Anonymous Window. also please attach the screenshot of the output.