1. a) Create a table bank_masterColumn NameDatatypeVarchar2(4)Varchar2(30)Varchar2(30)Number (7)b) Insert the records using the following table valuesConstraintaccountnoNot NullnameaddressamountaccountnonameAddressamount101MohamedBurka9000102NasserNizwa8000103KhamizSohar8200104MurshidBurka7800106MustasimSohar9500a) Create a table bank_detailsColumn NameDatatypeVarchar2(4)number(4)dateConstraintRecurrent_acnoNot Nullac_noTransaction_dateFixed_depositNumber(8)b) Insert the records using the following table valuesRecurrent_acno | ac_noTransaction_dateFixed_depositС10110112.05.200210000C10210213.01.202080000C10310314.02.202150000C10110413.05.202040000C10210515.06.2019null 6) Write an SQL query to find the minimum fixed deposit of each recurrent_acno whosetransaction_date between 12.05.2002 and 13.05.2020 and their fixed_deposit amount 10000 or40000

Statement to create table: CREATE TABLE bank_details ( Recuurent_acno VARCHAR(24), ac_no INT,…

Answered: 6) Write an SQL query to find the…

6) Write an SQL query to find the minimum fixed deposit of each recurrent_acno whose transaction_date between 12.05.2002 and 13.05.2020 and their fixed_deposit amount 10000 or 40000

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Write a query in SQL to list the titles of the employees for a specific date

A: Hello student Greetings Hope you are doing great. Thank You!!!

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: the each customer total annual premium and order by the highest total annual premium to the least.…

A: I have written the query below:

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

A: Answer: Oracle: CREATE FUNCTION Return_region_name(region_id IN NUMBER)RETURN NUMBERIS region_name…

Q: In sql get to know the HR database, its tables, and their contents. Show the SQL query and the…

A: SQL: SQL stands for a structured query language, it used to manage the data and organize the data in…

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

A: Required:

Q: Find the service ID and property ID for each service request whose estimated hours is greater than…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: Write a SQL query to find the employee I'd whose salary lies in between 3000 and 11000.

A: Question. Write a SQL query to find the employee Id whose salary lies in between 3000 and 11000.…

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: Student(StudentID, age) School(SchoolID, city) Write an SQL statement for the following query: For…

A: The above question is solved in step 2:-

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…

Q: Please write SQL codes to create a sequence and name it member_seq and use it to populate below data…

A: Given: Write SQL codes to create a sequence and name it member_seq and use it to populate below data…

Q: SQL queries

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

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 an SQL query to display: The last name of the student who registered at the last. Your output…

A: Write SQL query to display the last name of the student who registered at the last. Given: The…

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: Write an appropriate SQL query to delete the following record from the STUDENTS table:…

A: Answer: We need to write the query for the delete the record from the table so we will see in the…

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

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

Q: Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours…

A: Please check the step 2 for required sql code

Q: Write an appropriate SQL query to update the STUDENT_SURNAME for the student with STUDENT_ID…

A: Complete answer in mySQL query is given below:

Q: Write an appropriate SQL query to determine which student is registered for the most credits (total…

A: In this question we have to write a sql query for given statement and table. Let's complete the sql…

Q: Write an SQL query that will show all order numbers in the Orders tablebetween 1002 and 1008

A: SQL query: Query to show all order numbers in the “Orders” table between 1002 and 1008 SELECT * FROM…

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: List all book information for the book or books which sold for the average price of all books sold…

A: We need to display all book information for the book or books which sold for the average price of…

Q: Write a sql query to show first name, job number and department number of those employees whose…

A: The queries for both questions given below

Q: Write an sql query to fetch all those employees who work on projects other then P1

A: The SQL query is given below with OUTPUT screenshot

Q: Please write the MySQL query for the following task: Find the first_name, last_name, employee_id,…

A: we can use the following MySQL query:

Q: write my sql , p/sql pr t-sql procedures to retrieve and output the item id, description, location,…

A: Your mysql query is given below.

Q: Write a SQL query to show the names of all students who have studied both ECON123 and ECON456 (NOTE:…

A: A query can either be a request for data results from your database or for action on the data.

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: Write a SQL Query that uses the annual growth to get a projection for total population for the years…

A: Given tables are: table_1: CountryName, Year, AnnualGrowth, CumulativeGrowth table_2:CountryName,…

Q: 1. a) Create a table bank_master Column Name Datatype Varchar2(4) Varchar2(30) Varchar2(30) Number…

A: Given that We have to create table Bank_Master and insert data into it Part 2 We have to create…

Q: 4. Write the SQL code to enter the following data for table STUDENT. StudentID StudentName Phone…

A: The SQL query for inserting the data in the STUDENT table is given below

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 that will show all data from the Customers table andOrder By State.

A: SQL query: Query to select all the data from the “Customers” table order by “State” SELECT * FROM…

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: Write and run an SQL query to list all students and courses they are registered for. Include, in…

A: Given: To Write and run an SQL query to list all students and courses they are registered for.…

Q: Write a SQL query to find the highest salary from the table Salaries(E_ID, E_Name, E_Post, Salary)

A: Given Table: Salaries(E_ID, E_Name, E_Post, Salary) Requirement: Find the highest salary from the…

Q: Write a SQL query, which shows a list of all employees last name, their department names and their…

A: SELECT e.last_name, COALESCE(d.department_name, 'N/A') as department_name,…

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;

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

1. a) Create a table bank_master
Column Name
Datatype
Varchar2(4)
Varchar2(30)
Varchar2(30)
Number (7)
b) Insert the records using the following table values
Constraint
accountno
Not Null
name
address
amount
accountno
name
Address
amount
101
Mohamed
Burka
9000
102
Nasser
Nizwa
8000
103
Khamiz
Sohar
8200
104
Murshid
Burka
7800
106
Mustasim
Sohar
9500
a) Create a table bank_details
Column Name
Datatype
Varchar2(4)
number(4)
date
Constraint
Recurrent_acno
Not Null
ac_no
Transaction_date
Fixed_deposit
Number(8)
b) Insert the records using the following table values
Recurrent_acno | ac_no
Transaction_date
Fixed_deposit
С101
101
12.05.2002
10000
C102
102
13.01.2020
80000
C103
103
14.02.2021
50000
C101
104
13.05.2020
40000
C102
105
15.06.2019
null

6) Write an SQL query to find the minimum fixed deposit of each recurrent_acno whose
transaction_date between 12.05.2002 and 13.05.2020 and their fixed_deposit amount 10000 or
40000

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Write an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16 with 32 in the SupplierID attribute inthe Products table.
Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January 1, 1994, and whose job code is at least 501. When you finish Problems 7–15, the EMP_2 table will contain the data shown in Figure P8.15.
Write an SQL query to find numbers of months between the dates 12/12/2020 and 12/12/2021. Also find last day in month 12.
By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number and department name should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
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
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100
Write an SQL query to list the order number and order quantity for all customer orders for which the order quantity is greater than the average order quantity of that product. (Hint: This involves using a correlated subquery.)
write a PL/SQL procedure to find the Maximum of the two values
Write an sql query to find the maximum, minimum, and average salary of the employees
Write SQL query to add default value 1000.
SQL Database Write PL/SQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of persons, and trip price for every reservation whose customer number is stored in I_CUSTOMER_NUM
Write an SQL query to determine the total number of hours and the total number of lessons Tutor 106 taught in June and July 2015.