Browse S

SQL Query HELP pls. SQL Query HELP pls. 1. Find the First and last names and add

SQL Query HELP pls. SQL Query HELP pls. 1. Find the First and last names and addresses of employees who work on at least one project that is not located in Stafford but works in t…

SQL Query I have a working JavaFX program that acts as an SQL Client that opens

SQL Query I have a working JavaFX program that acts as an SQL Client that opens MS Access databases and can run queries and output to tableview. I need to add some functionality a…

SQL Query List drug information (Pharmaceutical company name, trade name, formul

SQL Query List drug information (Pharmaceutical company name, trade name, formula) that has been prescribed by at least one doctor. Retrieve the pharmacies that sell more than 2 t…

SQL Query Problems: 1. List the event number, customer name, contact name, and a

SQL Query Problems: 1. List the event number, customer name, contact name, and authorization date where the event request has been approved but there is not an event plan. 2. List…

SQL Query Question: So I have a database with the tables below, data has also be

SQL Query Question: So I have a database with the tables below, data has also been aded into these tables, My question is a skill called 'thinking' needs to be changed to 'Deep th…

SQL Query help: Each branch has many employees but only one branch manager. Each

SQL Query help: Each branch has many employees but only one branch manager. Each payment transaction has a unique ID, transaction amount, transaction method (cash, debit, or credi…

SQL Query of following table: Tables are in attached images: 1. List the details

SQL Query of following table: Tables are in attached images: 1. List the details of the courses with subject code CMPT. 2. For every registration list the name of the student and …

SQL Query on Multiple Tables—JOIN 1. Display employee number, first name, middle

SQL Query on Multiple Tables—JOIN 1. Display employee number, first name, middle name, last name and the job description for all the employees. The order of columns for the displa…

SQL Query question... Hi, hope someone can help with this I have a table called

SQL Query question... Hi, hope someone can help with this I have a table called customers with columns: ID, firstname, lastname, phone, email. The table has 9 rows. I have made a …

SQL Question - it\'s a basic one, but I need some help. I have to write raw SQL

SQL Question - it's a basic one, but I need some help. I have to write raw SQL to create and insert data into a database and table. I've already created the table(empty) and the d…

SQL Question 5 Examine the table below and write the SQL command that will displ

SQL Question 5 Examine the table below and write the SQL command that will display all the products from the products table where the price is more than $40 Products ProductName P…

SQL Question; CREATE TABLE department (DEPARTMENT_ID NUMBER (4) PRIMARY KEY, DEP

SQL Question; CREATE TABLE department (DEPARTMENT_ID          NUMBER (4)        PRIMARY KEY, DEPARTMENT_NAME       VARCHAR2(20)      NOT NULL UNIQUE, LOCATION              VARCHAR…

SQL Review Exercise Spring 2015 Given a company database schemas as below: EMPLO

SQL Review Exercise Spring 2015 Given a company database schemas as below: EMPLOYEE Lname Ssn Bdate Address Sex Salary Super ssn no Frame Minit DEPARTMENT Dname Dnumbe Mgr ssn Mgr…

SQL SERVER 2014 You think you finally have established the rules for determining

SQL SERVER 2014 You think you finally have established the rules for determining which students belong to which campus. Your reports clearly label your methodology so there is les…

SQL SERVER QUESTION Use the following database: https://codeshare.io/aJQQZ6 Use

SQL SERVER QUESTION Use the following database: https://codeshare.io/aJQQZ6 Use   USER_TAB_PRIVS and SYSTEM_PRIVILEGE_MAP to display every step you created; Create user name devel…

SQL SERVER QUESTION Use the following database: https://codeshare.io/aJQQZ6 Use

SQL SERVER QUESTION Use the following database: https://codeshare.io/aJQQZ6 Use   USER_TAB_PRIVS and SYSTEM_PRIVILEGE_MAP to display every step you created; Create user name devel…

SQL STUDIO ERROR: i have an invalid column error at \'rownumber

SQL STUDIO ERROR: i have an invalid column error at 'rownumber<=75' SELECT v.eolt_scenario_id, v.scenario_value, v.scenario_value_ecu, v.scenario_value_name, o.eolt_sequence_id…

SQL Script /* Step 3a. Copy the anonymous program in Step 1 and remove all refer

SQL Script /* Step 3a. Copy the anonymous program in Step 1 and remove all references to the symbolic constant con_today and its output. In your declaration section,declare variab…

SQL Select Data and Order By In this question, you are going to select some data

SQL Select Data and Order By In this question, you are going to select some data rows from a table with a certain order Data from Big Ten Statistics is contained in a table offens…

SQL Server 1. Create a stored procedure that takes a Recipe Name as input and th

SQL Server 1. Create a stored procedure that takes a Recipe Name as input and the output is a list of ingredients with Qty and Measurement Unit. 2.Create a Stored Procedure that t…

SQL Server 2012 Write a SELECT statement with a ranking function to return produ

SQL Server 2012 Write a SELECT statement with a ranking function to return product data in five columns: ProductID, SupplierID, UnitPrice, CategoryID, and 'Price Rank by Supplier'…

SQL Simple Question on duplicate entry mySQL said: #1062 - Duplicate entry \'214

SQL Simple Question on duplicate entry mySQL said: #1062 - Duplicate entry '2147483647' for key 'PRIMARY' The following code isn't working (especially the bolded part in fourth li…

SQL Single Table Queries For each information request below, formulate a single

SQL Single Table Queries For each information request below, formulate a single SQL query to produce the required information. Read the problems carefully and in each case, you sh…

SQL So i did a sub query which gave a correct result of displaying 3 persons. An

SQL So i did a sub query which gave a correct result of displaying 3 persons. And then I was assigned bringing those 3 persons again using sql code but with equi join, but then in…

SQL Statement Course courseID (PK) courseName MGMT329 Database Management MGMT33

SQL Statement Course courseID (PK) courseName MGMT329 Database Management MGMT330 Business Programming MGMT450 Computer Based Information Systems 1:M Relationship (1 Course to Man…

SQL Suppose that we have a table of positive integers up to 100, as in lecture:

SQL Suppose that we have a table of positive integers up to 100, as in lecture: Question: Define a table divisors in which each row describes the number of unique divisors for an …

SQL Table Creation Homework Due 2 April 1. You own a farm (ok, a big farm) and w

SQL Table Creation Homework Due 2 April 1. You own a farm (ok, a big farm) and want to start a DB to keep track of important things. In particular vou want to keep track of crops …

SQL Table I have a bug in this code veggieID : Int // the key for this table day

SQL Table I have a bug in this code veggieID : Int   // the key for this table daysToHarvest : Int Check < 80 ( a required check in the table) watering : Decimal(4,2) is the es…

SQL The database you will use for this assignment contains information related t

SQL             The database you will use for this assignment contains information related to Major League Baseball (MLB) about players, teams, and games. The relations are: Playe…

SQL The database you will use for this assignment contains information related t

SQL             The database you will use for this assignment contains information related to Major League Baseball (MLB) about players, teams, and games. The relations are: Playe…

SQL The database you will use for this assignment contains information related t

SQL             The database you will use for this assignment contains information related to Major League Baseball (MLB) about players, teams, and games. The relations are: Playe…

SQL There are \"lazy\" artists in Chinook - artists that are not associated with

SQL There are "lazy" artists in Chinook - artists that are not associated with any albums. Write a query to produce a list of these artists, sorted by artist name (alphabetically)…

SQL There is a single track with \"odd\" pricing: it is either an audio track wh

SQL There is a single track with "odd" pricing: it is either an audio track whose price is not $0.99 or it is a video track whose price is not $1.99. Write a query to identify thi…

SQL This database has 3 tables Student(StudentID, Name, BirthDate, Address, GPA)

SQL This database has 3 tables Student(StudentID, Name, BirthDate, Address, GPA) Course(CourseID, Name, StartDate, EndDate, Credit, Instructor) Registration(StudentID, CourseID, L…

SQL This is a three (3) part question that parallels our Perl homework, where yo

SQL This is a three (3) part question that parallels our Perl homework, where you created information about your favorite team. #!/usr/bin/perl # Perl Assignment - Hash of Hashes …

SQL Transactions Exercises Consider table Item(name,price) where name is a key,

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*pri…

SQL Transactions Exercises For the universal relation R(w,x,y,z), consider the d

SQL Transactions Exercises For the universal relation R(w,x,y,z), consider the decomposition D consisting of R1(w,y,z) and R2(x,y), and the set F of functional dependencies { y-&g…

SQL Transactions Exercises Perform the test for the non-additive join property (

SQL Transactions Exercises Perform the test for the non-additive join property (lossless join) for the relation R(A1, A2, A3, A4, A5), and the decompositions Da, Db, Dc, Dd and se…

SQL USING CHINOOK DATABASE SCHEMA 1.1 IN JAVA CAN SOMEONE PLEASE HELP ME FIX THI

SQL USING CHINOOK DATABASE SCHEMA 1.1 IN JAVA CAN SOMEONE PLEASE HELP ME FIX THIS CODE. I AM HAVING TROUBLE GETTING THE PREPARED STATEMENT TO RETURN THE RESULTS. import java.sql.C…

SQL Use the UNION operator to generate a result set consisting of two columns fr

SQL Use the UNION operator to generate a result set consisting of two columns from the Vendors table: VendorName and VendorState. If the vendor is in California, the VendorState v…

SQL Which type of join question? Select one of the following! ARPB_TRANSACTIONS

SQL Which type of join question? Select one of the following! ARPB_TRANSACTIONS is a table which stores one row for every charge, payment, and adjustment in your professional bill…

SQL Write a SELECT statement then returns two columns from the GLAccounts table:

SQL Write a SELECT statement then returns two columns from the GLAccounts table: AccountNo and AccountDescription. The result set should have one row for each account number that …

SQL Write a query to identify the single track that has no composer and is on bo

SQL Write a query to identify the single track that has no composer and is on both the "Grunge" and the "90's Music" playlists. Your query must not hardcode any numeric ids (e.g. …

SQL Write a statement which displays the customer\'s last name, customer\'s firs

SQL Write a statement which displays the customer's last name, customer's first name and the total amount the customer has ever spent. Display the customer's name only once regard…

SQL and Algorthim Question: Can someone please answer these question with regard

SQL and Algorthim Question: Can someone please answer these question with regards to A and B as well as a through explanation. I will give good ratings for an correct answer. 1. C…

SQL and Database Questions QUESTION 6 0.5 points Save Answer Below is a partiall

SQL and Database Questions QUESTION 6 0.5 points Save Answer Below is a partially complete CREATE TABLE statement for the Orders table in the Clothing Store database. Consider it …

SQL and Relational Algebra Consider the automobile insurance company database we

SQL and Relational Algebra Consider the automobile insurance company database we use for examples in class. For each problem, write an SQL statement to retrieve the specified data…

SQL assignment Do not turn in an MDB (MS Access database) file or any other data

SQL assignment Do not turn in an MDB (MS Access database) file or any other database file. Write your SQL script in a text editor or word-processor and then turn in a word-process…

SQL chapter 4 As you do the exercises, unless it is stated otherwise, you will b

SQL chapter 4 As you do the exercises, unless it is stated otherwise, you will be using the tables from our standard Student- Course database. Also, as you do the exercises, it wi…

SQL coding help Query 1: Which guest(s) (only list the guestNo) have stayed in b

SQL coding help Query 1: Which guest(s) (only list the guestNo) have stayed in both hotelNo 2 and hotelNo 4? Query 2: which hotels (only list the hotel number) do not have family …