Write all the sql code (including create, insert and select) Create the following tables in your database with the following schema:Table: UsersI Column Name| Type+--intI account| name| varchar+-----+-----account is the primary key for this table.Each row of this table contains the account number of each user in the bank.Table: Transactions| Column Name| Туре+-| trans idI account| amount| transacted_on | date| int| int| int+--trans id is the primary key for this table.Each row of this table contains all changes made to all accounts.amount is positive if the user received money and negative if theytransferred money.All accounts start with a balance of 0.Add the following data to your tables:Input:Users table:+---I accountI name+---| 900001| 900002| 900003| Alice| Bob| CharlieTransactions table:+--| trans id| account| amount| transacted_on+---| 1| 2| 3| 900001| 900001| 900001I 900002| 900003| 900003| 900003| 7000I 7000| -3000| 1000| 6000| 6000| -40002020-08-012020-09-012020-09-022020-09-1252020-08-072020-09-07| 72020-09-11+-- Write an SQL query to report the name and balance of users with a balance higher than 10000. Thebalance of an account is equal to the sum of the amounts of all transactions involving that account.Return the result table in any order.The results should be:Output:I namebalance| Alice11000Explanation:Alice's balance is (7000 + 7000 -Bob's balance is 1000.3000) = 11000.Charlie's balance is (6000 + 60004000) = 8000.

#use the below query to create users tablecreate table users(account int primary key,name…

Answered: Write all the sql code (including…

Engineering

Computer Science

Write all the sql code (including create, insert and select)

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: list of clauses in sql. Give examples of very clauses.

A: sql clause facilitates us to retrieve a hard and fast or bundles of information from the table. sql…

Q: Oracle SQL Packages Create a stored procedure to display top three of cheapest course in terms of…

A: To return the smallest value of the selected column we use the MIN( ) function. And to return the…

Q: Write a complete PL/SQL Cursor to retrieve the following information -Fetch row number, Employee id,…

A: Before executing the PLSQL statement first execute the command SET SERVEROUTPUT ON;. Otherwise the…

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: In SQL, what numeric data formats are available?

A: Tip Numeric data types are used to store numbers in database tables. Typically, these data formats…

Q: Given two database table i_users(userid,username,email address,isActive,gender) stores the users…

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

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: a) Group all…

A: Process To display the all the data we use select * from tablename and condition what we want to get…

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: List at least 3 differences between Oracle PL/SQL programming functions and procedures (Differences…

A: Differences between Oracle PL/SQL programming functions and procedures S.N. function…

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: Determine the number of different customers who have placed an order for books written or cowritten…

A: 9. Determine the number of different customers who have placed an order for books written…

Q: PL/SQL please use oracle sql developer. I know it would be hard to slove without the data but please…

A: Query for passenger info between dates.

Q: What is true about table functions in standard SQL? (a) table functions can operate on only one…

A: The table-valued function is a function that is able to return tables. Hence, correct answer is…

Q: What is an index in SQL? Also write it's syntax.

A: An index contains keys built from one or more columns in the table or view. These keys are stored in…

Q: Execute a SQL statement to delete the column status from order_db.

A: The DELETE statement in SQL is a powerful tool for putting off data from a database desk. It allows…

Q: Q1. Create a stored procedure that will list all customers (name and number) represented by rep 15.…

A: create table cust_records(cust_num int primary key,cust_name varchar(30));insert into cust_records…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

Write all the sql code (including create, insert and select)

Create the following tables in your database with the following schema:
Table: Users
I Column Name
| Type
+--
int
I account
| name
| varchar
+--
---+
-----
account is the primary key for this table.
Each row of this table contains the account number of each user in the bank.
Table: Transactions
| Column Name
| Туре
+-
| trans id
I account
| amount
| transacted_on | date
| int
| int
| int
+--
trans id is the primary key for this table.
Each row of this table contains all changes made to all accounts.
amount is positive if the user received money and negative if they
transferred money.
All accounts start with a balance of 0.
Add the following data to your tables:
Input:
Users table:
+---
I account
I name
+---
| 900001
| 900002
| 900003
| Alice
| Bob
| Charlie
Transactions table:
+--
| trans id
| account
| amount
| transacted_on
+---
| 1
| 2
| 3
| 900001
| 900001
| 900001
I 900002
| 900003
| 900003
| 900003
| 7000
I 7000
| -3000
| 1000
| 6000
| 6000
| -4000
2020-08-01
2020-09-01
2020-09-02
2020-09-12
5
2020-08-07
2020-09-07
| 7
2020-09-11
+--

Write an SQL query to report the name and balance of users with a balance higher than 10000. The
balance of an account is equal to the sum of the amounts of all transactions involving that account.
Return the result table in any order.
The results should be:
Output:
I name
balance
| Alice
11000
Explanation:
Alice's balance is (7000 + 7000 -
Bob's balance is 1000.
3000) = 11000.
Charlie's balance is (6000 + 6000
4000) = 8000.

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 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

A SQL Data Manipulation command like UPDATE or INSERT immediately saves the result to disk without further intervention from the user. Question 31 options: 1) True 2) False
Please help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION. Please explore the database and then write the appropriate SQL command. List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order. Find all patients rows whose first names include ‘George’ (Assume case sensitivity). sql doc below Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
Which SQL Command is used to delete a table from the database: a) Update b) Alter c) Drop d) Select
Using php and sql: create a query that will output only the user_id and message for user_id 8
in SQL Code: Explain the difference between number and binary integer and how it is used? Please provide a code example
DO NOT COPY FROM OTHER WEBSITES Upvote guarenteed for a correct and detailed answer. Thank you!!!
answer with proper explanation and step by step solution. Question write a PL/ SQL program to display the number of products whose price is 100 dh more or less than the price defined the for substitution variable use the define command to specify the price pass this value to the PL/SQL black using a substitution variable
Explain replace and translate functions in Oracle sql
Describe the use of the CAST and CONVERT functions in SQL.
How can you dynamically execute a SQL query in PL/SQL? a. Using EXECUTE IMMEDIATE statement b. Using DBMS_SQL package c. Using FETCH statement d. Using OPEN-FOR statement