Browse S

SQL commands to find min, max, etc This is an exercise to try out the SQL comman

SQL commands to find min, max, etc This is an exercise to try out the SQL commands, of Group By and aggregation functions, Sum Avg, Max, Min See the attachment for examples of how…

SQL database: Write your query to retrieve data from the table. Link to get the

SQL database: Write your query to retrieve data from the table. Link to get the databse: https://drive.google.com/file/d/0B0kVn308bqFuVV9PZXQxZDF1ME0/view?usp=sharing a. show all …

SQL error Please fix A manager wants to know the email address, number or orders

SQL error Please fix A manager wants to know the email address, number or orders, and the total amount of purchases made by each customer. Create a summary query that returns thes…

SQL for these questions can be found at bottom. I need the answers to work in Or

SQL for these questions can be found at bottom. I need the answers to work in Oracle 12c 1. Show the average number of crimes reported by an officer. 2. Show the total number of c…

SQL help 1) Write a query that finds all students that have taken CIS182 and ear

SQL help 1) Write a query that finds all students that have taken CIS182 and earned an A in the Schedule.sql database. (Here is the Schedule.sql) -- cis182 final exam database cre…

SQL help Homework #1-Creating Tables Create a database with the following tables

SQL help Homework #1-Creating Tables Create a database with the following tables, correctly identifying the data type for each field and implementing constraints as described. Pri…

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matte

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matters Can someone please write the proper queries for this question? There are two parts to it. Link t…

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matte

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matters Can someone please write the proper queries for this question? There are two parts to it. Please…

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matte

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matters Can someone please write the proper queries for this question? There are two parts to it. I'm no…

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matte

SQL help using Oracle Database - NOT MYSQL OR MICROSOFT SQL SERVER! Syntax matters I'm not allowed to use BEGIN/END statements (don't even know what that means he hasn't taught us…

SQL homework. 1. Write a SELECT statement that returns these columns from the Pr

SQL homework. 1. Write a SELECT statement that returns these columns from the Products table: The list_price column A column that uses the TO_CHAR function to return the list_pric…

SQL in MS Access 1. By Last Name, First Name order, what is the GPA for each stu

SQL in MS Access 1. By Last Name, First Name order, what is the GPA for each student? 2. Which course appears to be the hardest based off of GPA? StudentGrade OnlineCourse CourseI…

SQL in Oracle. This is a two part question with a little backgound. This is what

SQL in Oracle. This is a two part question with a little backgound. This is what I did for 5-2 (which is used for the question I need help with). SQL> create table Stutab ( 2 "…

SQL in Oracle. Write, exicute and print a query to list student names and grades

SQL in Oracle. Write, exicute and print a query to list student names and grades (just two attributes) using the table alias feature. Restrict the list to students that have eithe…

SQL in Oracle. Write, exicute and print a query to list student names and grades

SQL in Oracle. Write, exicute and print a query to list student names and grades (just two attributes) using the table alias feature. Restrict the list to students that have eithe…

SQL injection attacks are not a new type of attack. In fact, they are a fairly o

SQL injection attacks are not a new type of attack. In fact, they are a fairly old and well-understood attack that virtually all security practitioners are aware of and adept at p…

SQL injection on a search The way Search performs its task is by executing the f

SQL injection on a search The way Search performs its task is by executing the following query (in a php script):          $var=stripslashes($_POST['search']);          $query = "…

SQL injection tips/warnings: =T-SQL injection warnings or tips found on the Micr

SQL injection tips/warnings: =T-SQL injection warnings or tips found on the Microsoft Web site or elsewhere online that are specific to Microsoft SQL Server, or =PL/SQL injection …

SQL plus chapter 7 Create a table called Secretary with the attributes “dcode CH

SQL plus chapter 7 Create a table called Secretary with the attributes “dcode CHAR(4)” (for department code) and “name VARCHAR2(20)” (for the secretary name). Populate the table a…

SQL practice help ! Implementing Relationships Use the ALTER command to add prim

SQL practice help ! Implementing Relationships Use the ALTER command to add primary keys to the Operators, Vehicles and Trips tables. The primary key for each table should be base…

SQL problem. Please answer if youre 100% sure, and answer all parts for a thumbs

SQL problem. Please answer if youre 100% sure, and answer all parts for a thumbs up ! Problem1 Consider a database consisting of a single relation M: 10 a) The following two trans…

SQL problems SID: cName. major decision 123.3 Cornell EE 1223 OSU. LCS Y 123 OSU

SQL problems SID: cName. major decision 123.3 Cornell EE 1223 OSU. LCS Y 123 OSU. EE 1233 U of O CS Y CS, N3 123e MIT. 2345 of O biology N3 345 Cornell bioengineering 345 Cornell …

SQL problems. Please help Use Priemiere Products database to complete the follow

SQL problems. Please help Use Priemiere Products database to complete the following exercise. 9. Use a subquery to find the rep number, last name, and first name of each sales rep…

SQL problems: Task – Create a transaction that given a invoiceId will delete tha

SQL problems: Task – Create a transaction that given a invoiceId will delete that invoice (There may be constraints that rely on this, find out how to resolve them). Task – Create…

SQL programming I need to truncate numbers on a table and Im not sure how to do

SQL programming I need to truncate numbers on a table and Im not sure how to do that. Based on the table below I need to modify the query to, Display surface area with 0 places af…

SQL programming. Consider the following Relational Database Schema for a DVD col

SQL programming. Consider the following Relational Database Schema for a DVD collection: DVD(releaseNo, title, releaseDate, mainLanguage, director, genre) primary key releaseNo AC…

SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is define

SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is defined as the primary key. Address has been denormalized to include City and State for performance reaso…

SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is define

SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is defined as the primary key. Address has been denormalized to include City and State for performance reaso…

SQL queries and procedures according to the below TABLES STRACTURES TABLE: Emplo

SQL queries and procedures according to the below TABLES STRACTURES TABLE: Employees Business Rules: EmployeeID is defined as the primary key. Address has been denormalized to inc…

SQL queries help 1. Display the Product ID of all products with its associated P

SQL queries help 1. Display the Product ID of all products with its associated Product Model ID and Model Name (by using JOIN) 2. Display the Product Model Name together with a co…

SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART Please Help me ou

SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART Please Help me out in these queries. 1) Get supplier names for suppliers who supply the parts. Blue Parts. 2)    Get…

SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART Please Help me ou

SQL queries on following Tables SUPPLIERS,PARTS, SUPPLIER_PART Please Help me out in these queries. 3.   Get all pairs of supplier numbers who reside in the same city. s (Supplier…

SQL queries: Write a query that returns a list of unique product departments and

SQL queries: Write a query that returns a list of unique product departments and the sales, orders, and average order size (i.e. sales/orders) of purchases (orderlines) in each de…

SQL query assistance: Find the fname and lname of all people who are assigned to

SQL query assistance: Find the fname and lname of all people who are assigned to at least one instance of a Viper class ship (this includes all variants of Viper class ships). Ret…

SQL query need help. The tables is below: customer(c_custkey, c_name, c_address,

SQL query need help. The tables is below: customer(c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment) lineitem(l-orderkey, l_partkey, l_suppke…

SQL query question Well I\'m stuck.... I have a database with two tables, Produc

SQL query question Well I'm stuck.... I have a database with two tables, Products and salesman. I am tasked with displaying the salesman_Firstname, salesman_Lastname colums from t…

SQL query... query. Ok heres my task: Return the salesman first name, last name

SQL query... query. Ok heres my task: Return the salesman first name, last name and total of the product price for the listings made by each salesman. You need to return only thos…

SQL question ! 2. (12 marks) Consider the relations in a banking database given

SQL question ! 2. (12 marks) Consider the relations in a banking database given by the schemas below. BRANCH (branchName, address, city, sales, manager) CUSTOMER (cID, firstName, …

SQL question Consider the following relational schema. Emp(eid integer, ename: s

SQL question Consider the following relational schema. Emp(eid integer, ename: string, age: integer, salary: real) Works (eid: integer, did: integer, pet-time: integer) Dept (did:…

SQL question Please pay attention to the requirements, there should be four cond

SQL question Please pay attention to the requirements, there should be four conditions. answer this question: --Finding out all the guests who stayed in Grosvenor hotel during Sep…

SQL question answer this question: --Finding out all the guests who stayed in Gr

SQL question answer this question: --Finding out all the guests who stayed in Grosvenor hotel during September. *according to the professor, there should be four conditions: see t…

SQL question. My assignment is to create the following mini database. I don\'t k

SQL question. My assignment is to create the following mini database. I don't know how to reference the composite primary key in the Lot _Permit_Type table. Also, would you look i…

SQL question: Netflix wants to find out the most popular movies for teenagers an

SQL question: Netflix wants to find out the most popular movies for teenagers and young adults. A recent research finding indicates that “PG”, “PG13”, and “R” rated movies with an…

SQL questions Question 5 1. A user view in which the WHERE line of the SELECT st

SQL questions Question 5 1.       A user view in which the WHERE line of the SELECT statement used to create the view contains some predicate is called A. value-dependent B. stati…

SQL questions. Suppose that set A is the set of student names who have made an A

SQL questions. Suppose that set A is the set of student names who have made an A or B in computer science (COSC) courses. Suppose further that set B is the set of students who hav…

SQL questions: (2) A relation R(A,B,C,D,E) has exactly four superkeys: CDE, ACDE

SQL questions: (2) A relation R(A,B,C,D,E) has exactly four superkeys: CDE, ACDE, BCDE and ABCDE. State the canddiate key(s). (3) It is known that R(A,B,C,D,E) have two candidate …

SQL questions: 1. Creation of an audit table which will be populated each time a

SQL questions: 1. Creation of an audit table which will be populated each time a books retail price or cost is changed 2. Creation of a trigger to populate the audit table describ…

SQL questions: 1. W rite a single statement that creates and populates a table c

SQL questions: 1. W rite a single statement that creates and populates a table called books_on_sale which has the same data structure and contains all of the data as the books tab…

SQL script data into database 1) The University hired a new professor to teach a

SQL script data into database 1) The University hired a new professor to teach a new class. The name of the class is ENG250 and is called “Ways To Learn”. Professor Luke will be t…

SQL script: Please write SQL statements for the following questions: 1. Get supp

SQL script: Please write SQL statements for the following questions: 1. Get supplier names for suppliers who supplied parts for jobs only in Athens. (Double negation; Use a nested…