Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked, sorted by employee number. The results of running that query are shown in Figure P7

Write an SQL query using the NOT operator that will show all employeeinformation from the Employee table with the exception of EmployeeNumber 7344.

What are some common uses for the STRING_AGG function in SQL?

SQL ( ORACLE SQL DEVELOPER ) :  THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve  :    create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) );     create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) );     create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 );     insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British');     insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…

Write a query in SQL code for: "List the book categories and the average book price of each category."  Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY

Using DML SQL, write the appropriate SQL query for each of the following:a) Insert A new customer with the following information:(Name: Ali, SSN: 1111, Address: Riyadh, Phone: 05555)b) Delete all the loans for customer with SSN: 2222c) Select all customer who got loans more than 250000 SAR, print the customers SSN, named) Print all the Accounts in Bank: ALBILAD and in branch no: 5

Need help writing SQL statements for these, I'm having trouble with my returns. Explanation would help a lot.

Consider the tables provided below and answer the following SQL questions: Table 1: Service SereicelD SereiceName Accounting. Security Maintenance Table 2: ServiceSetUp SereicelD SetupFee 2 3 4 100 300 350 Recurring 25 50 125 Tax 10% 11 9% Questions: Write insert statements to enter first two records into Table 1 as shown in above figure. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of the service that has setup fee greater than $300. d. Display average of tax rates for all services.

Write the T-SQL scripts for the following tasks: Write a query to list the first name and last name of the employee with the highest salary in the financedepartment

Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).