4. Excel file Credit Risk Data provides information about 425 bank customers who applied for loans. The data include the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, age, housing status and number of years at current residence, job type, and credit-risk classification by the bank.   a. Use an Excel function to determine how many customers applied for different loan purpose such as new-car, used-car, business, education, small-appliance, and furniture loans   b. Figure out the number of customers who applied for new car with at least $1,000 savings account balance.

Q: 12. Report the names of the professors who supervise more than one student. 13.  Report the names…

A: In order to find professors who supervise more than one student, we will need a COUNT() function on…

Q: Provide a summary of customer balance characteristics for customers who made purchases. Include the…

A: Actually the given information is Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Q: During the month of January, an employer incurred the following payroll taxes: FICA Social Security…

A: Debit Payroll Tax Expense: $819 Credit FICA Social Security Taxes Payable: $372 Credit FICA…

Q: WEB Development Lab Final exam 7/July/2021 Q) Create a SQL data base containing a table concerned…

A: Command to create database family and opening database named family Command to create table named…

Q: ng problem statement. Retrieve the customer name, service description, employee name, employee…

A: I have completed the query to fullfil to data to retrive according to the conditions I have used…

Q: Cust_id (NOT NULL) Txn_date (Not NULL) Txn_type (NOT NULL) Txn_amount (NOT NULL) 1 2020-01-21…

A: The CREATE TABLE statement is used to create a new table. Syntax: CREATE TABLE table_name (column1…

Q: What is the appropriate data type to hold an employee's salary?

A: Numeric data types are normally used to store data like price, salary etc. Such data types have a…

Q: b. Write SQL. queries for the following staterments. i Display all the employee's details in the…

A: As the data is not provided, I used the dummy data, and queries are solved using the MySQL database.…

Q: Please see the attached and assist with below question. Using the “Aggregates” worksheet, complete…

A: The given problem is to complete the given excel for an income tax calculation using MS EXCEL and…

Q: g  Make sure to use oracle sql command and add foreign keys The faculty and students (we refer to…

A: The given requirements are related to the creation of data model using details provided for the…

Q: How would one start this? Bank SQL   Using a procedure and trigger) System should be able to…

A: Answer: I have done code  and also I have attached code as well as code screenshot.

Q: Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with…

A: A relational database contains tables. Tables are also called relations and they contain rows and…

Q: Task 12: List the item ID, description, and category for each pair of items that are in the same…

A: Creating table ITEMS: create table ITEMS(item_id varchar2(5) Primary Key,Description…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: Please start from declare the variable  Using SQL*Plus and SQL Developer tool, complete the…

A: Structured query language is a querying database perform query against given data

Q: se are the frequent item S sample transactions,

A: To find, Provide support values Provide confidence values Provide lift values Discuss on the…

Q: Given the employees of medium-sized semi-conductor firm, find the employee that joined November 8,…

A: The Excel INDEX function returns a value in an array based on the row and column numbers you…

Q: View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file…

A: Actually, the answer has given below:

Q: please code this in SQL Language

A: The database generation code in mysql is provided below:

Q: Ed Engineering Section (C) Coding and Relational Algebra (Each question 1- What will be the result…

A: Answer..

Q: 7. Create the following table DEPT_TAB: DEPTID 2 digits Primary key DNAME 25 characters Not null LOC…

A: Given:

Q: Q16) List the V_CODE and V_NAME of vendors that provide products Q8) List the product description,…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: Column Name Sie Constraints Data Type DepelD Varchar 4 Primary key DepeName 40 Not mull Varchar…

A: I have created the query below for the table:

Q: Write SQL statements for each task:

A: 1. The query for the first part is as follows: Select e.equipmentCode AND e.name AND e.description…

Q: Question 1 Use Index and math functions to fill in a table that extracts the amounts shipped…

A: The task at hand involves using Excel's Index and math functions to populate a table displaying the…

Q: o an existing order, include the product id, unit price, quantity. The output of the function is the…

A: given - Create a function to insert a new product into an existing order, include the product id,…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: Exists a technique to distinguish between the benefits and drawbacks of different authentication…

A: Introduction  In this question we are asked Exists a technique that distinguishes between the…

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :

Q: use the following data to shown minimum and maximum and average of parts unit price

A: Parts table: Creating parts table: create table parts (PartNo varchar(5)  primary key,Description…

Q: CUST_ID 78   CUST _ID 54     NAME YORK UNIVERSITY   NAME SENECA COLLEGE     LOCATION…

A: Given, CUST _ID NAME LOCATION SALES_REP 78 YORK UNIVERSITY NORTH YORK ANDRE MARTIN 54 SENECA…

Q: 1. Report the student names and ages of all students who have a "hotmail" email address. Sort the…

A: 1. Report the student names and ages of all students who have a "hotmail" email address. Sort the…

Q: 1. Which SQL statement inserts data into a table called Projects? a) INSERT Projects ('Content…

A: Introduction: Structured Query stands for Structured Query Language. Language is a programming…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Queries: 1. Do a query to show name of the resource, building, category and plan to use code for a…

A: Query to show name of the resource, building, category, and plan to use code for a particular plan…

Q: sql queries

A: Given :- A relational database schema is given as, Team (tname, year, coach, salary) Player (pname,…

Q: a) List the names (Fame and Lame) and SSN of all male employees (Sex='M). b) List the last name and…

A: As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…

Q: Write a program that illustrates the application of multiple catch statement

A:

Q: 3. Determine the amount of total profit generated by the book purchased on order 1002. Display the…

A: ANSWER:-

Q: Vacation days are based on status. Using the information in the lower table below, do a lookup in…

A: A lookup function is used to match a lookup value in a one-column or one-row range, and returns the…

Q: Q14) how many products with price < 10

A: You have asked multiple questions so we will solve the first one for you. If you want any other…

Q: You have the following table:   MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT)   Write…

A: Stored procedures in a relational database management system (RDBMS) are powerful tools for…

Q: Create a function to determine the total pledge amount for a project. Use the function in an SQL…

A: SQL stands for standard query language.It is a domain specific language used in programming and…

Q: Write the SQL statements to perform the following operations: a. Create a new course “CS-001”,…

A: SQL (Structured Query Language) is a standard programming language for managing relational…

Q: A SQL Data Manipulation command like UPDATE or INSERT immediately saves the result to disk without…

A: DML commands The commands like UPDATE or INSERT are called data manipulation commands which are used…