Browse S

SQL Hello I need to create a VIEW base on this table thank you 3 Start Page olum

SQL Hello I need to create a VIEW base on this table thank you 3 Start Page olumns Data Model |Constraints Grants Statistics Triggers Flashback Dependencies Details |Partitions In…

SQL Help Compare the code in Advising.sql to the description below. Identify thr

SQL Help Compare the code in Advising.sql to the description below. Identify three ways the code fails to implement the description. a) A student can have one or more majors, and …

SQL Help How would you change the query below to display the grades for all stud

SQL Help How would you change the query below to display the grades for all students who have a grade? SELECT last_name + ', ' + first_name Student, department + ' ' + number Cour…

SQL Help This question uses the code in Schedule.sql. The query below is intende

SQL Help This question uses the code in Schedule.sql. The query below is intended to calculate how much each enrolled student will owe for each Winter 2003 course he's taking, ass…

SQL Help This question uses the code in Schedule.sql. What does the code in bold

SQL Help This question uses the code in Schedule.sql. What does the code in bold describe? SELECT department + ' ' + number Course, schedule_quarter + ' ' + schedule_year QuarterY…

SQL Help This question uses the code in Schedule.sql. What question is this quer

SQL Help This question uses the code in Schedule.sql. What question is this query answering? SELECT *           FROM course_catalog                    WHERE courseid IN           …

SQL Help This question uses the code in Schedule.sql. a) Which table is the foll

SQL Help This question uses the code in Schedule.sql. a) Which table is the following query about? SELECT department + ' ' + number Course, schedule_quarter + ' ' + schedule_year …

SQL Help True/False a) DML commands are used to edit data in a database. (T/F) b

SQL Help True/False a) DML commands are used to edit data in a database. (T/F) b) Use the equal sign to test for Null. (T/F) c) The tests below will both return the record where t…

SQL Help Use the file to create the initial database and tables. Require Using C

SQL Help Use the file to create the initial database and tables. Require Using Create 1. Create a table that implements the many-to-many relationship between titles and authors. I…

SQL Help Will replacing the field ss.studentid with * in the count function affe

SQL Help Will replacing the field ss.studentid with * in the count function affect the result of this query? Should the asterisk be used in place of the field name? SELECT departm…

SQL Help a) Using the code in Advising.sql below, identify the tables and relati

SQL Help a) Using the code in Advising.sql below, identify the tables and relationships in the database. (Here is the Advising.sql) CREATE DATABASE studentMajors GO USE studentMaj…

SQL Help!! Three part question: 1. List Top 10 customers by their names who orde

SQL Help!! Three part question: 1. List Top 10 customers by their names who ordered the most quantity and their country of origin. (double inner join) 2. List top 5 customers of f…

SQL Help!! Three part question: 1. List Top 10 customers by their names who orde

SQL Help!! Three part question: 1. List Top 10 customers by their names who ordered the most quantity and their country of origin. (double inner join) 2. List top 5 customers of f…

SQL Help, I am new to SQl and trying to solve: For a book with ISBN 978075640407

SQL Help, I am new to SQl and trying to solve: For a book with ISBN 9780756404079, display it’s title, publisher, ISBN, which library (not branch) has it, and total number of copi…

SQL Homewonk Using MySOL Assignment 4 COP3703 Instructions: Prepare and execute

SQL Homewonk Using MySOL Assignment 4 COP3703 Instructions: Prepare and execute each of the queries listed using the "sakila" database in MySQL Use the schema shown below. When al…

SQL Homework 1 The schema of the database is provided below (keys are in bold, f

SQL Homework 1 The schema of the database is provided below (keys are in bold, field types are omitted): . student (sid, studentName, gpa) * dept (deptName, numPhDs) prof (profNam…

SQL Homework Exercises: 1. Examine the structures of the PLAYER and TEAM tables:

SQL Homework Exercises: 1. Examine the structures of the PLAYER and TEAM tables: PLAYER ------------- PLAYER_ID NUMBER PK LAST_NAME VARCHAR2(30) FIRST_NAME VARCHAR2(25) TEAM_ID NU…

SQL Homework Exercises: Please choose the correct answer/s letter. 1. Examine th

SQL Homework Exercises: Please choose the correct answer/s letter. 1. Examine the structures of the PLAYER and TEAM tables: PLAYER ------------- PLAYER_ID NUMBER PK LAST_NAME VARC…

SQL Homework exercises: 1. Write INSERT statements that add two rows to the Memb

SQL Homework exercises: 1. Write INSERT statements that add two rows to the Members table for member IDs 1 and 2, two rows to the Groups table for group IDs 1 and 2, and three row…

SQL Homework exercises: exercise 2: CREATE TABLE users ( user_id int Primary key

SQL Homework exercises: exercise 2: CREATE TABLE users ( user_id int Primary key NOT NULL, email_address VARCHAR(20), first_name VARCHAR(20), last_name VARCHAR(20) ); CREATE TABLE…

SQL Homework: 1. Write INSERT statements that add two rows to the Members table

SQL Homework: 1. Write INSERT statements that add two rows to the Members table for member IDs 1 and 2, two rows to the Groups table for group IDs 1 and 2, and three rows to the G…

SQL Homework: exercise 2: CREATE TABLE users ( user_id int Primary key NOT NULL,

SQL Homework: exercise 2: CREATE TABLE users ( user_id int Primary key NOT NULL, email_address VARCHAR(20), first_name VARCHAR(20), last_name VARCHAR(20) ); CREATE TABLE downloads…

SQL How to create DML scripts to update table Customers and set Customer_Status_

SQL How to create DML scripts to update table Customers and set Customer_Status_Id to the correct value for each of the customers? Data model for Customer and customer_status: -he…

SQL I have 3 tables which are: Book( key , year, title) size of 1400000, A( key

SQL I have 3 tables which are: Book(key, year, title) size of 1400000, A( key, .... , ....) size of 560000 datas and B(key, .. , ..) size of 850000 datas. A and B are both type of…

SQL I need help with the following question I would like to focus on my job tabl

SQL I need help with the following question I would like to focus on my job table, that states a job not started, quality control, and completion of customers I have attach screen…

SQL I need help with the following question. Thank you Consider the CRETE TRIGGE

SQL I need help with the following question. Thank you Consider the CRETE TRIGGER command shown in the figure(lines 105 through 113) Also remember that invoice_id is the primary k…

SQL I need help with the following question. Thank you Consider the tablc struct

SQL I need help with the following question. Thank you Consider the tablc structurc shown in tha fiqure DATA TYTE NUMEER NUMBER (null) 2 inull) 3 (null) (null) 5 (null) (null) 7 (…

SQL I need help with the following question. Thank you Consider the table struct

SQL I need help with the following question. Thank you Consider the table structure shown INVOICES Columns Data Constraints Grants Statistics ITriggers |Flashback IDependencies ID…

SQL I need help with the following question. Thank you Consider the table struct

SQL I need help with the following question. Thank you Consider the table structure shown in the figure TERMS Columns Data lConstraints Grants IStatistics ITriggers Flashback IDep…

SQL I need to demonstrate an update that includes two tables and uses a subquery

SQL I need to demonstrate an update that includes two tables and uses a subquery. I need to develop at least four meaningful reports. One must include a join, one must use a subqu…

SQL Inner Join Question. Select all that apply! LOG tables You write a query to

SQL Inner Join Question. Select all that apply! LOG tables You write a query to compare surgical cases and logs, represented by the OR_CASE and OR LOG tables, respectively. If a l…

SQL Inner Join Question. Select all that apply! You write a query to return pati

SQL Inner Join Question. Select all that apply! You write a query to return patients and their primary care providers (PCP). If a patient has a current PCP, the column CUR_PCP_PRO…

SQL Introduction Consider the following relational database that Delta Airlines

SQL Introduction Consider the following relational database that Delta Airlines uses to keep track of its mechanics, their skills, and their airport locations. Mechanic number (ME…

SQL Joins and Aggregations Using W3SCHOOLS SQL is located at http://www.w3school

SQL Joins and Aggregations Using W3SCHOOLS SQL is located at http://www.w3schools.com/sql/default.asp 1) Write a query to show Customers' Country wise sales totals. Your query sho…

SQL Language Show owners with unpaid bill ( an order is classified as unpaid if

SQL Language Show owners with unpaid bill ( an order is classified as unpaid if the paid indicator is = "No"), listing the owner name, owner phone, business number, business name,…

SQL Left Outer Join Question. Select one of the following! Which of the followin

SQL Left Outer Join Question. Select one of the following! Which of the following performs a left outer join from the PAT_ENC_HSP table to the CLARITY_EMP table where PAT_ENC_HSP.…

SQL MS Acess 1. Display cid, clast, and cfirst for customers whose (last name st

SQL MS Acess 1. Display cid, clast, and cfirst for customers whose (last name starts with a “D” and has a “v” in the third position) or (first name ends with an “a”). 2. Display a…

SQL MS access 1.List the Faculty (First and Last Names) by Department. 2.What pe

SQL MS access 1.List the Faculty (First and Last Names) by Department. 2.What percentage of the total budget does each department get? StudentGrade OnlineCourse CourseID URL Enrol…

SQL Matrix Manipulations Two random 3x3 (N = 3) matrices have been provided in t

SQL Matrix Manipulations Two random 3x3 (N = 3) matrices have been provided in tables A and B, having the following schema: i INT: Row index j INT: Column index val INT: Cell valu…

SQL Multi-Table COUNT/JOIN Help Write an SQL query that will show the number of

SQL Multi-Table COUNT/JOIN Help Write an SQL query that will show the number of services performed for each customer and the total cost of those services. You will need informatio…

SQL Multi-Table COUNT/JOIN Help Write an SQL query to create a list of all the s

SQL Multi-Table COUNT/JOIN Help Write an SQL query to create a list of all the services ever performed, including the number of times they have been performed and the total cost o…

SQL NUMBER 20 CAN NOT USE INNER JOIN LEFT JOIN OR RIGHT JOIN 18. Display all the

SQL NUMBER 20 CAN NOT USE INNER JOIN LEFT JOIN OR RIGHT JOIN 18. Display all the columns in Assignment for those that have one or more rows in Hours. Your overall strategy must be…

SQL ORACLE QUESTION GuestID IDEN ll Y (1500,1) CREDITCARD requires EPK Creditcar

SQL ORACLE QUESTION GuestID IDEN ll Y (1500,1) CREDITCARD requires EPK Creditcard!D Smallint has GUEST ROOMTYPE PK GuestID smallint FK1 GuestID smallint CCType varchar (5) GuestFi…

SQL ORACLE QUESTION How write a statement to add a new Credit Card for yourself

SQL ORACLE QUESTION How write a statement to add a new Credit Card for yourself (using the @@IDENTITY value for the FK Guest ID Number that was issued when you did query #1). Cred…

SQL ORACLE QUESTION ResID IDENTITY 5000.1 Guest ID IDENTITY (1500,1) CREDITCARD

SQL ORACLE QUESTION ResID IDENTITY 5000.1 Guest ID IDENTITY (1500,1) CREDITCARD uires RESERVATION PK CreditCardlD smallint has- ROOM TYPE PKK GuestID smallint FK1 GuestID smallint…

SQL ORACLE Question. Display the hotel name, room number (not id), room descript

SQL ORACLE Question. Display the hotel name, room number (not id), room description, and rack rate for all rooms with a rack rate at or above $138.00 per night (valid during the m…

SQL Oracle Database 11g question: Following the example in Lecture 4 Set echo on

SQL Oracle Database 11g question: Following the example in Lecture 4 Set echo on SET SERVEROUT ON Set up a spool file to receive your output for submission. I would suggest c:cs42…

SQL Oracle TASK - Create a function that returns the length of a mediatype from

SQL Oracle TASK - Create a function that returns the length of a mediatype from the mediatype table. I am not sure how I am suppose to get the code below to work. Below is what I …

SQL PLUS exercies As you do the exercises, it is a good idea to copy/paste your

SQL PLUS exercies As you do the exercises, it is a good idea to copy/paste your query as well as your query result into a word processor. 3-1. Stu sname Jones Smith Evans Adams Cr…

SQL PROBLEM I just need to write a single SQL query for each of the question. ER

SQL PROBLEM I just need to write a single SQL query for each of the question. ERD diagram is up there. 1.Which movies were created by a company with "films" in its name. List the …