Create a PL/SQL query to display the combined customer name, coin purchased, coin price and the delivery notes. In your query only display the coins purchased with a price less than or equal to R 8 000. Sample Output: CUSTOMER: Mat, Smith COIN: 1oz Gold Kruger Rand PRICE: R5 999 NOTES: Double packaging requested CUSTOMER: Lucy, Williams COIN: 1oz Gold Kruger Rand PRICE: R5 999 NOTES: No notes CUSTOMER: Sam, Clark COIN: loz Silver Palaeontology PRICE: R7 999 NOTES: Delivery to work address

Q: 1. Table : ASSIGNMENT D ASSIGNMENT N NMAON DATE MM EMP MUN AiNO AlON CHO AONHOURI NON CHA 35 42 t00…

A: Explanation In SQL, the SELECT query is used to fetch or retrieve the data from the database table.…

Q: Write the SQL code that will compute the total number of hours worked and total amount billed by all…

A: To compute the total number of hours worked and total amount billed by all workers, we need to have…

Q: Write SQL queries to answer the following questions:a. Which studen ts have an ID number that is…

A: SQL queries are given below

Q: Write a SQL query to count the number of orders that have a purchase amount greater than 1000

A: SUMMARY: - hence we discussed all the points

Q: CUSTOMER aus CODE CUS LNAME CUS FNAME CuS INITIAL CUS AREACODE CuS PHONE CUS BALANCE PRODUCT P cODE…

A: SQL (Structured Query Language) is a database query language. According to ANSI, it is the…

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: How do I create a query that includes first name, last name, email and state for all customers and…

A: Query:-   SELECT first_name, last_name, email, state, CASE WHEN customer_type = 'Customer' THEN 'C'…

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

A: Required:

Q: Using Pubs: USE MICROSOFT SQL SERVER Create a query listing all the books that Barnum’s purchased.…

A: I attached your answer below.

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: In SQL Code: Write code snippet to show how value from Bind Variable can be passed to a PL/SQL…

A:

Q: Using My SQL Workbench Find all cities in Argentina whose name begins with S or M a. display city…

A: Logic:-  To display names that begins with any character , use like operator and put first character…

Q: Write the SQL query to find all the place whose temperature is 38. SELECT place WHERE temperature…

A:

Q: Write the following as the MySQL query:  List the employee ID, first name, last name, hire date,…

A: In database administration, it is frequently essential to extract particular data from a dataset…

Q: Create a PL/SQL query to display the customer name, employee name and the coin product returned. In…

A: Create table ReturnDetails(CustomerName varchar(30),EmployeeName varchar(30),CoinReturn…

Q: Select clause and from clause: Display the columns specified above in the problem  statement from…

A: Write a query to display the author ID, first name, last name, and year of birth for all authors…

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

A: Explanation: SQL contains “ORDER BY” clause in order to sort rows. The values get sorted in…

Q: Create a SQL query to generate the required report containing the combined customer name, employee…

A: A Database Management System is a software application or system that enables the creation,…

Q: Write the SQL code required to list the first name and last name of all customers whose middle…

A: Writing the SQL code required to list the first name and last name of all customers whose middle…

Q: Q3: How many unique titles do we have in the employee table? Hint: You need to create TWO queries,…

A: 1)   SELECT DISTINCT titles FROM EMPLOYEE

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: Print out names, phone numbers, house ID, and status of people who live in the same house as anyone…

A: Database: A database acts as a storage of data. A large amount of data is being stored in the…

Q: Write the following as MySQL query: Find the department name whose location (Country_ID) is DE. Use…

A: SQL, which stands for Structured Query Language, is a domain-specific programming language used for…

Q: Write a SQL query to calculate the total purchase amount of orders that have an even ID number

A: SQL Query are very useful to fetch the required data from database in the table form In this…

Q: 7) Write a query to display Unique order dates from the shipper named “Speedy Express”.

A: According to Bartleby Guidelines we need to answer only one question so I have answered first…

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

A: THE GIVEN SQL QUERRY FOR THE QUESTION

Q: Write a query to display all vendors sorted by vendor name.   Write a query to display the product…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Based on the following SQL statement: SELECT acct_id, balance FROM Account WHERE balance < 0 AND…

A: Number list = [12,9,2,5,-7,3]. Bubble sort: In bubble sort works by repeatedly swapping the adjacent…

Q: salary is above 4000 and job_id starts with a letter “S”

A: 1. SELECT * FROM employee WHERE (salary &gt; 4000) AND job_id LIKE 'S%'   2. SELECT              *,…

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: Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM.…

A: Answer:-

Q: Create a function to increment the salary of employees of an organization by 15%, and for employees…

A: Create a function in PL/SQL to increment the salary of employees of an organization by 15%, and for…

Q: Write an SQL query using the IN operator to show all customers residingin the following zip codes:…

A: As the database is not given we have assumed the database CUSTOMERS. SQL query to create table…

Q: The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all…

A: Answer

Q: Write an SQL query using the AND operator that show all orders shoppedon April 1, 2009 shipped to…

A: SQL query: SELECT * FROM Orders WHERE order_date = ‘April 1, 2009’ AND state = ‘Florida’;

Q: Consider the below two tables for reference while trying to solve the SQL queries for practice.…

A: The answer for the above question is given in the following steps for your reference.

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: Write PL/SQL or T-SQL procedures to retrieve and output the item number, description, storehouse…

A: Program: Query: CREATE OR REPLACE PROCEDURE ITEM_CATGRY_PROC ( I_ITEM_NUM OUT ITEM.ITEM_NUM%TYPE,…

Q: Write a query in SQL to display all the data of customers, in Table customers, that live in New York…

A: If any of the conditions separated by OR is TRUE then the OR operator displays a record. All fields…

Q: Write an SQL query using the NOT operator that will show all employeeinformation from the Employee…

A: SQL query: SELECT * FROM Employee WHERE NOT Employee_Number = 7344;

Q: Write an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16…

A: Update statement: The UPDATE statement in the SQL is used to modify existing records present in the…