sql database multiple choice questions.. To make a report that contains all information about each student who's full name or address contains 'K':O a. select * from students where concat(full_name concat(address)) like '%k%';b. select * from students where concat(full_name,address) like '%k%';O c. select * from students where full_name or address like '%k%';O d. select * from students where full_name and address like '%k%'; The query:select max(course_level) from courses join registration using(course_id);displays:O a. Makes error.O b. The maximum course level in table courses.O c. The maximum course level for the courses registered in table registration.O d. The maximum course_id in table registration.

NOTE - As per our guidelines we are supposed to answer only one question. Kindly repost other…

To make a report that contains all information about each student who's full name or address contains 'K': O a. select * from students where concat(full_name concat(address)) like '%k%'; b. select * from students where concat(full_name,address) like '%k%'; O c. select * from students where full_name or address like '%k%'; d. select * from students where full_name and address like '%k%';

To make a report that contains all information about each student who's full name or address contains 'K': O a. select * from students where concat(full_name concat(address)) like '%k%'; b. select * from students where concat(full_name,address) like '%k%'; O c. select * from students where full_name or address like '%k%'; d. select * from students where full_name and address like '%k%';

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section5.1: Elements Of An Excel Table

Problem 7QC

See similar textbooks

Similar questions

The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…
SQL code for: (1) Hint: A NULL in the hours column should be considered as zero hours. Find the ssn, lname, and the total number of hours worked on projects for every employee whose total is less than 40 hours. Sort the result by lname */ /* (2) For every project that has more than 2 employees working on it: Find the project number, project name, number of employees working on it, and the total number of hours worked by all employees on that project. Sort the results by project number. /* (3) For every employee who has the highest salary in their department: Find the dno, ssn, lname, and salary. Sort the results by department number. */ /* (4) For every employee who does not work on any project that is located in Houston: Find the ssn and lname. Sort the results by lname /* (5) Hint: This is a DIVISION query For every employee who works on every project that is located in Stafford: Find the ssn and lname. Sort the results by lname */
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
Where stud_type_id=student_type.id AND student_type.name='local'
How many days, years did quitting employees work in their past jobs. Name Null? Туре ΕMPLOYEE_ID FIRST_NAME LAST_NAME NUMBER (6) VARCHAR2 (20) NOT NULL VARCHAR2 (25) ΕΜΑIL NOT NULL VARCHAR2 (25) PHONE_NUMBER VARCHAR2 (20) NOT NULL DATE HIRE_DATE JOB_ID NOT NULL VARCHAR2 (10) NUMBER (8,2) NUMBER (2,2) SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID NUMBER (6) NUMBER (4) Name Null? Туре NOT NULL NUMBER (6) ΕMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMENT_ID NOT NULL DATE NOT NULL DATE NOT NULL VARCHAR2 (10) NUMBER (4)
Q2) how many vendors provide productQ3) how many products each vendor providesQ4) ?How many vendors (unique vendors) have products with price < 10Q5) increase the product price 10% if the orginal price is leass than 50
Write SQL Query that display department id and department name that employs fewer than five employees Write SQL Query that display department id and department name that has the highest number of employees Write SQL Query that display department id and department name that has the lowest number of employees
1- List all the users and their card name using union2- List all the users and their card name using Intersection 3- List all the card numbers with owner names and scheduled transactions, in case the user hasnever used scheduled transaction show null or zero in the transaction column. (Hint use ISNULLfunction)
What is MINR minimum value across a range of value?
Show all female’s first names and their salary. Show the branchno that has a supervisor whosesalary is greater than 15000. Show the first name and birthday for all femalestaff whose birthday is before 1950-01-01. List of monthly salaries for all male staff,showing the staff number, the first and lastnames, and the salary details.
WEEK 9 ASSIGNMENT#6 Part II: Complete the following exercise: Using a subquery, select student first name where the student is in the student course table. Using a subquery, select the course id where the average GPA is 2. Using a subquery, select the course id where the average GPA is greater than 2. Using a subquery, select student first name where the student is not in the student course t
Consider the following set of requirements for a university database that is used to keep track of students' of student enrollments in classes and students' final grades: a. The university is organized into colleges (COLLEGE), and each college has a unique name (CName), a main office (COffice) and phone (CPhone), and particular faculty member who is dean of the college. Each college administers a number of academic departments (DEPT). Each department has a unique name (RName), a unique code number (RCode), a main office (ROffice) and phone (RPhone), and a particular faculty member who chairs the department. We keep track of the start date (CStartDate) when that faculty member began chairing the department. b. A department offers a number of courses (COURSE), each of which has a unique course name (COName), a unique code number (CCode), a course level (Level: this can be coded as 1 for freshman level, 2 for sophomore, 3 for junior, 4 for senior, 5 for MS level, and 6 for PhD level), a…