Create a PL/SQL query to display the invoice number, coin name, coin price and delivery notes. In your query determine whether the coin product is a premium or standard product. All coins that are valued at R10 000 and above are considered Premium coins. In your query use invoice number 8115 only. Sample Output: INVOICE NUMBER: 8115 COIN PRODUCT: 1oz Gold Palaeontology PRICE: R 11999 DELIVERY NOTE: Birthday present wrapping required COIN TYPE: Premium

Q: Create a Procedure in PL/SQL takes employee_id, rate_salary, rate_commission. This function will…

A: Find the required procedure in PL/SQL given as below :

Q: Write a query to list the first name and last name of all authors. Concatenate the first and last…

A: The SQL query is: SELECT CONCAT(CONCAT(firstname,' '),lastname) AS FullName FROM author;…

Q: PLZ make the following work sql Write a query to display the membership number, first name, last…

A: SELECT b.MEM_NUM, a.MEM_FNAME, a.MEM_LNAME,a.MEM_BALANCE,RENT_DATEFROM MEMBERSHIP a, RENTAL b where…

Q: Using the university schema, write an SQL query to find the number of students in each section. The…

A: SQL Query: SELECT s.course_id, s.sec_id, s.year, s.semester, count(id) AS numFROM takes t, section…

Q: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Write a SQL query that selects OrderID and OrderDate from the Orders table and OrderDetailID from…

A: Introduction: A JOIN clause is used to merge data from more than "2" tables based on a standard…

Q: 3) Write an SQL query to display the accountno, name, Recurrent_acno, transaction_date whose Fixed…

A: Required:

Q: write sample sql quiries for these Write a query to display employee number, first name, job id…

A: Please refer below for your reference: Queries are: 1. SELECT employee number, first name, job id…

Q: In SQL, Using the DUAL table, create a query that will return the current day of the week, hour,…

A: SELECT convert(varchar(10), GETDATE(), 108) 'time', DATENAME(weekday,GETDATE()) 'day of the week'…

Q: Using DML SQL, write the appropriate SQL query for each of the following: Insert A new customer…

A: SQL:- Big data SQL or structured query language can be regarded as the base or medium of…

Q: Create a PL/SQL query to display the invoice number, coin name, coin price and delivery notes. In…

A: create the table Bill which contains the following fields, Bill number product price delivery note…

Q: Use %ROWTYPE for your cursor. You will use 3 tables in this activity – departments, locations, and…

A: It is defined as a combination of SQL along with the procedural features of programming languages.…

Q: You have to only develop a SQL query Write a query to display the resort name, rate of all the…

A: Here have to determine about sal query for given scenario.

Q: Write the T-SQL scripts for the following tasks: Write a query to select the count of employees…

A: SELECT     COUNT(*)FROM    employees_tableWHERE    department = "Marketing";

Q: First create a query for cursor..  cursor  cur1   as SELECT e.first_name, e.last_name, e.salary,…

A: CREATE TABLE EMPLOYEE( EMPLOYEE_FNAME VARCHAR(10), EMPLOYEE_LNAME VARCHAR(10), JOB_ID VARCHAR(5),…

Q: Write a T-SQL query to display the emp code, emp lname, employee job code, from the employee table…

A: Screenshot- DB is designed as per the SQL create DB and insert statements.

Q: Write a query to generate the total number of invoices, the invoice total for all of the invoices,…

A: Structured Query Language (SQL) has some built-in functions they are : “SUM()” - This function is…

Q: 6. Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query…

A: The first query should validate the the ASSIGN_CHARGE values in the ASSIGNMENT table. ASSIGN_CHARGE…

Q: SQL queries

A: According to the question, we need to write the SQL queries of the following questions: Write a…

Q: Write a query to display student Id who registered for the course 1001, 1005. If they registered for…

A: Required: We have to write a sql query to display student Id who registered for the course 1001,…

Q: Based on this design, write a query in SQL to display the book's title, the publisher's name, the…

A: Introduction: A query is used to fetch the data from the database or table. The syntax to fetch the…

Q: Use %ROWTYPE for your cursor and use 3 tables in this activity - EMPLOYEES, JOBS, and DEPARTMENTS…

A: PL/SQL is a programming language that combines SQL with procedural capabilities. Oracle Corporation…

Q: lease implement the following using Oracle live/SQL Developer: 1- Create the DONORS table with the…

A: please do upvote for my efforts !   answer: 1) CREATE TABLE DONORS(    donor_id int primary key,…

Q: Create a procedure in PL/SQL takes Department Id and return record data type has maximum salary,…

A: Find the required procedure in PL/SQL given as below :

Q: Write SQL Command to display all employees details whose job id is either AD_VP or PU_MAN. Order the…

A: We are given Employess table which contain all the attributes asked in query, so we will use…

Q: Using DML SQL, write the appropriate SQL query for each of the following: Insert A new customer…

A: In SQL, DML stands for Data manipulation language which contains Select, Insert, Delete and Update…

Q: Write a query to display the author ID, first and last name for all authors that have never written…

A: We indeed to provide SQL query to display the author ID, first and last name for all authors that…

Q: Write the following inserts, deletes, or updates in SQL, using the universityschema. Insert every…

A: Explanation: In the below query, “insert, select, into, from and where” are the keywords used. The…

Q: Write a query to display the mobile model name which has made the maximum sales. Give an alias for…

A: According to the given question here we have to develop a SQL code that display the mobile  model…

Q: Write a query to display the customer code, balance, and total purchases for each customer. Total…

A: SQL query: The Select statement is used for retrieving data from a database. The SQL code for…

Q: Write an SQL query using the ALTER TABLE and ADD operator to add anattribute named ORDERDATE with…

A: ALTER TABLE command: The ALTER TABLE command is used to add new columns, modify columns in an…

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows:   )…

A: Below is the required procedure:

Q: IN SQL write a query to get the names of all Students who passed the exam from the table…

A: Required:

Q: Modify the following SQL command so that the Rep_ID column is the PRIMARY KEY for the table and the…

A: Actually, SQL stands for Structured Query Language.

Q: In the SQL Oracle Application, Within the Employees table, each manager_id is the manager of one or…

A: Answer: SELECT  manager_id, job_id, SUM(salary) "total salary", GROUPING(manager_id),…

Q: Write the SQL code

A: SQL code: SELECT Emp_Num, Emp_LName, Emp_FName, Emp_Initial  FROM EMPLOYEE WHERE Emp_LName LIKE ':…

Q: 6. Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query…

A: Hey, since multiple questions posted, we will answer first question according to our policy. If you…

Q: 6. Write an SQL query to display the ID, ITEMNAME, CUSTOMERNAME and price is not equal 35000 and…

A: As per Bartleby's guidelines “Since you have posted a question with multiple sub-parts, we will…

Q: Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query should…

A: UPDATE ASSIGNMENT SET CALC_ASSIGN_CHARGE = ASSIGN_CHG_HR* ASSIGN_HOURS;

Q: Write a query to display the author ID, first and last name for all authors that have never written…

A: From a database, required information can be retrieved by the query language. The queries must be in…

Q: Write sql code for Use derived tables and joins to create a list of players who have scored more…

A: Fielding Table is not given but it is mentioned to consider same as other table. So, we can join all…

Q: sql   In the orders table, group by ship_via, employee_id, ship_country fields, where the ship_via…

A: Given table name: orders Field names to display: count of the number of items as total and the…

Q: Q11. Write an SQL query to do the following: a. Create table customer_info with the given details.…

A: Using CREATE statement we can create table in SQL.  Syntax: CREATE TABLE Table_Name(Column1_Name…

Q: Create a PL/SQL query to display the combined customer name, coin purchased, coin price and the…

A: given Data is

Q: I have the following problem for which I wrote teh code, but I am missing to round the last column…

A: Solution: Following is the query that retrieves  assignment number, employee number, project number,…

Q: 8- Write a query to generate the total number of invoices, the invoice total for all of the…

A: Objective: A query should be written to display the total number of invoices, the invoice total for…

Q: Write two SQL Queries that will show the ORDER# from both the Orderand OrderItems table using the…

A: In SQL the UNION clause combines the results of two SQL queries into a single table of all matching…

Q: Create a SQL query to display the combined customer name, employee id, delivery notes, coinordered…

A: Answer:)

Q: Write the following queries in SQL: Display the list of all course sections offered in Spring 2018,…

A: Here, we will use a SELECT statement to display the required result set along with the decode…