Trainer Trainer ID (PK) First Name Last Name Address Phone Date Of Birth SessionID (FK) H Session SessionID (PK) SessionName Room Name Date Started Status LeadTrainerID (FK) CustomerID (FK) +H Customer CustomerID (PK) Name Address ContactPhone

I would like to create a function to sum up total order amount within the date range, but i don't know how to write the right query. The query below is for counting the total orders, but I want to change to sum up total order amount. The Database table is attached. Please assist. ************************************** USE SQLBook; DROP FUNCTION IF EXISTS GetDateRangewithordersAmountGO CREATE FUNCTION GetDateRangewithordersAmount(       @startDate DateTime,    @endDate DateTime)RETURNS TABLE ASRETURN (    select [State], count (*) as [TotalOrderAmount]   FROM [SQLBook].[dbo].[Orders]   WHERE [OrderDate] between @startDate AND @endDate   group by [State])GO SELECT * FROM GetDateRangewithordersAmount('2015-09-01','2015-10-31');GO

I created a database that contains four tables department, employee,address and contact info, then I stored 5 Records in each table. by Writing the PL/SQL Statement I should retrieve departments and their employees using package.

In the Testa EV database design described in the previous question, please complete a field specifications form for the field 'Model_Cost' of the table 'Model_T'. The field records the cost of producing a specific EV model. Because its data come from the cost data of specific parts used to build the model, its value can be entered later and editing is allowed (null is allowed). The field value is required. Only decimal numeric data are supported for the entered value. The field can store a maximum of 10 digits (including 2 decimal places). The user of the database (data analyst) is responsible for entering and maintaining the data. No specific range of values is specified for this field. You should enter 'N/A' (or leave it unchecked) for elements that are not applicable.

The purpose of this activity is to create a working mini-database system from a user’s basic requirements. SQL DDL and DML must be used to create, populate and update tables.   This database is for a typical Columbus car dealership. We will keep track of all the cars on the lot. For each car we will track the model ( modelA, modelB, modelC or make up your own), the list price, a status (available, sold) and a list of options the car has. A car may have more than one option (you may make these up, example: sun roof, power windows, …).. When the car is sold, we will keep track of the date, and the name of the salesman that sold the car. For each salesman, we will keep track of their name, gender, salary, and total amount sold.

Consignment shops offer a great service to our communities in that they allow us to purchase slightly used goods at very valuable prices. The original owners of these goods bring in their merchandise to selI. Upon selling the item, the consignment shop retains 25% of the sale for their services. You are working for a local shop. Every month the database, containing the sales data produces a report that details the amount sales per each original owner. Your job is to write a program that will help analyze this data. The array of sales data is as follows: owner sales = [201.45, 550.00, 117.65, 55.25, 5.95, 365.451 Your program needs to create 4 functions accomplishing the following tasks: main: This function will call all of your other functions, in the following order: Print Sales, Find Lowest and Determine Payout. It will also print the lowest sales. Print Sales: This function will print each sale. • Find Lowest: This function will find the lowest sale and print it. Determine Payout:…

Create a view vLab3_xxx in the  class database list the staff who have the highest salary in each of the branch city. You will need both Staff and Branch table. The output header should be (city, name, salary) where the name is "fname lname".

A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies.   Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (eg animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting is…