For this exercise use the following schema, the script to create this schema and populate data is given in ATM.SQL file.1- List all names of the users from Lahore in Descending Order.2- List all cards, who have card type “Credit” in ascending order.3- List the name of all the users who are Gold type.4- List the names of the user who’s Card number ends with 6. (HINT: USE LIKE) user TypelDname1Silver2Gold3Bronze44Commonuserlduser Type phoneNumcitynameAli203036067000 Narowal22Ahmed103036047000 Lahore3Аgeel303036063000 Karachi44Usman 403036062000 Sialkot55Hafeez 203036061000 LahoreuserlDcardNum11324327436569123432432534362232432542333623432432534363232432543656662324325423336cardNumcard TypelD PINexpire Date balance11324327436569 31770 2022-07-01 43025.312232432542333630234 2020-03-02 14425.623232432543656611234 2019-02-06 34325.5242324325666456 21200 2021-02-05 24325.32343243253436 20034 2020-09-02 34025.12card TypelDname description11Debit Spend Now, Pay NowCredit Spend Now, Pay later3GiftEnjoytransld transDatecardNumamount trans Type112017-02-02 1324327436569500122018-02-03 234324325343630003332017-05-06 2324325436566 25002442016-09-09 2324325436566 2000152015-02-10 2324325423336 60004trans TypelD typeName description11Withdraw NULL2DepositNULL3Schedul. NULL4FailedNULL234N3 UserUserCard* USER_ID* UserlD* CardNumNameUserTypeTransaction* Trans_IDphone_NumCityTransDateCardNumAmountCardTrans type* CardNumCardTypelDPINUserType* UserTypelDExpireDatebalanceNameTransactionType8 Trans_Type IDTypeNameCardType8 CardTypelDDescriptionNameDescription

Here I have given the SQL commands for the required operations. Since the database schema file is…

For this exercise use the following schema, the script to create this schema and populate data is given in ATM.SQL file. 1- List all names of the users from Lahore in Descending Order. 2- List all cards, who have card type “Credit” in ascending order. 3- List the name of all the users who are Gold type. 4- List the names of the user who’s Card number ends with 6. (HINT: USE LIKE)

For this exercise use the following schema, the script to create this schema and populate data is given in ATM.SQL file. 1- List all names of the users from Lahore in Descending Order. 2- List all cards, who have card type “Credit” in ascending order. 3- List the name of all the users who are Gold type. 4- List the names of the user who’s Card number ends with 6. (HINT: USE LIKE)

New Perspectives on HTML5, CSS3, and JavaScript

6th Edition

ISBN:9781305503922

Author:Patrick M. Carey

Publisher:Patrick M. Carey

Chapter13: Programming For Web Forms: Creatings Forms For Orders And Pa

Section13.2: Visual Overview: Passing Data Between Forms

Problem 3QC

See similar textbooks

Related questions

Q: WHY DO I get this error:SELECT TOP(3) p.name FROM publisher p ERROR at line 5: ORA-00923: FROM…

A: TOP command does not work in Oracle.

Q: Explain how each of the following types of integrity constraints is enforced in the SQL CREATE TABLE…

A: Answer: Definition: The limitations in the relational data model which is used to maintain the…

Q: Write a stored procedure in MySQL, PL/SQL, or T-SQL that changes the price of an item with a given…

A: Query: CREATE OR REPLACE PROCEDURE ITEM_CATGRY_PROC ( I_ITEM_NUM OUT ITEM.ITEM_NUM%TYPE,…

Q: Using the hoteldb schema, write SQL that will provide a list of Family Rooms and their prices. The…

A: For table ROOM, considering attributes of room as Room No, Type, Price then we need to join table…

Q: What is the difference between a SQL WHERE and SQL HAVING clause?

A: Answer: If "Where" clause is utilized to channel the records from a table that depends on a…

Q: Write the following queries in SQL, using the university schema. For each department, find the…

Q: using Oracle write and run a PL/SQL block that populates the table Malasiya_Suppliers --- from the…

A: Given data, write and run a PL/SQL block that populates the table Malasiya_Suppliers from the…

Q: Please give a detailed answer for the below three questions along with code examples. How would you…

A: Given: How would you retrieve a count of all items in an SQL table? What command allows you to…

Q: For this exercise use the following schema, the script to create this schema and populate data is…

A: SELECT a.City FROM User a INNER JOIN UserCard b ON a.User_ID = b.UserID INNER JOIN…

Q: Create an SQL command to satisfy the following scenario. based on the entities: Residential…

A: The four tables are Residential_students Transfer_students Exam_papers Exam_center

Q: Question:1 Create the following table in sql-plus through query? Student_info Reg_no…

A: 1> Student_ info table using sql-plus CREATE TABLE student_info ( reg_no varchar(10) not null,…

Q: the structure of the Ch07_LargeCo database shown above , use SQL

A: Hi and thanks for your question! Unfortunately it looks incomplete. Please resubmit the question…

Q: Consider the education database , where the primary keys are underlined. Give an expression in SQL…

A: 1) SELECT full_name, school_name FROM Student NATURAL JOIN School WHERE age>=10 AND age<=15

Q: This process will be documented schematically in the table below that will: - identify all SQL…

A: SELECT * FROM books;

Q: Refer the given table and answer the question that follow: TABLE : CLIENT Client no Client_Name…

A: Given, Two tables: Client Client_details

Q: For each salesperson, list the total number of orders by month for the year 2015. (Hint: If you are…

A: SQL (Structured Query Language) is designed primarily for managing data in a relational database…

Q: Using the university schema, write an SQL query to find the ID and name of each instructor who has…

A: SQL(structured query language) is used in relational databases to query information and manipulate…

Q: Write a query to find, name, hire_date, phone_number, department name for the employees in HR…

A: oehr_departments and oehr_employees are connected by department_id and manager_id in both the tables…

Q: Create the employees table and populate the table with data (Script is provided here with) (a) Write…

Q: USE this part to write SQL statements at the bottom questions 1-11 Branch(branch_id:integer,…

A: As per our company guidelines we are supposed to answer only first sub-parts. Kindly repost other…

Q: Given the structure and contents of the Ch07_ConstructCo database shown in FigureP7.1, use SQL…

A: Given the structure and contents of the Ch07_ConstructCo database shown in FigureP7.1, use SQL…

Q: Question 10 Format masks affect how Oracle stores the data. True False

A: Data masking assumes that you have created an application data model (ADM) with precise columns as…

Q: ANSWER IN ORACLE SQL PLEASE Write a query that identifies other customers who were referred to…

A: ELECT O.OrderDate,b.Title, (oi.PaidEach-b.Cost) as Profit from Customers c, Orders o, OrderItems oi,…

Question

For this exercise use the following schema, the script to create this schema and populate data is given in ATM.SQL file.

1- List all names of the users from Lahore in Descending Order.
2- List all cards, who have card type “Credit” in ascending order.
3- List the name of all the users who are Gold type.
4- List the names of the user who’s Card number ends with 6. (HINT: USE LIKE)

user TypelD
name
1
Silver
2
Gold
3
Bronze
4
4
Common
userld
user Type phoneNum
city
name
Ali
2
03036067000 Narowal
2
2
Ahmed
1
03036047000 Lahore
3
Аgeel
3
03036063000 Karachi
4
4
Usman 4
03036062000 Sialkot
5
5
Hafeez 2
03036061000 Lahore
userlD
cardNum
1
1324327436569
1
2343243253436
2
2324325423336
2343243253436
3
2324325436566
6
2324325423336
cardNum
card TypelD PIN
expire Date balance
1
1324327436569 3
1770 2022-07-01 43025.31
2
2324325423336
3
0234 2020-03-02 14425.62
3
2324325436566
1
1234 2019-02-06 34325.52
4
2324325666456 2
1200 2021-02-05 24325.3
2343243253436 2
0034 2020-09-02 34025.12
card TypelD
name description
1
1
Debit Spend Now, Pay Now
Credit Spend Now, Pay later
3
Gift
Enjoy
transld transDate
cardNum
amount trans Type
1
1
2017-02-02 1324327436569
500
1
2
2018-02-03 2343243253436
3000
3
3
3
2017-05-06 2324325436566 2500
2
4
4
2016-09-09 2324325436566 2000
1
5
2015-02-10 2324325423336 6000
4
trans TypelD typeName description
1
1
Withdraw NULL
2
Deposit
NULL
3
Schedul. NULL
4
Failed
NULL
234
N3

User
UserCard
* USER_ID
* UserlD
* CardNum
Name
UserType
Transaction
* Trans_ID
phone_Num
City
TransDate
CardNum
Amount
Card
Trans type
* CardNum
CardTypelD
PIN
UserType
* UserTypelD
ExpireDate
balance
Name
TransactionType
8 Trans_Type ID
TypeName
CardType
8 CardTypelD
Description
Name
Description

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

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

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

BASIC JQUERY .... https://www.w3schools.com/jquery/jquery_examples.asp?fbclid=IwAR0WWFC39ucCIUMykf0-bRja1lMcI0vBQoGdy6V_NuWH-1cZMTMf2l6Tndw
Fix the error to receive an SMS with GPS coordinates To acknowledge the user's SMS providerhttps://www.asiacell.com/en/personal/ #include <TinyGPS++.h> TinyGPSPlus gps; double latitude, longitude; #include <SoftwareSerial.h> SoftwareSerial SIM800L(11,10); String response; int lastStringLength = response.length(); String link; void setup() { Serial.begin(9600); Serial.println("GPS Mulai"); SIM800L.begin(9600); SIM800L.println("AT+CMGF=1"); Serial.println("SIM800L started at 9600"); delay(1000); Serial.println("Setup Complete! SIM800L is Ready!"); SIM800L.println("AT+CNMI=2,2,0,0,0"); } void loop() { if (SIM800L.available()>0){ response = SIM800L.readStringUntil('\n'); } if(lastStringLength != response.length()){ GPS(); //Perintah ON if(response.indexOf("FIND")!=-1){ //ganti FIND dengan keyword teman-teman SIM800L.println("AT+CMGF=1"); //Sets the GSM Module in Text…
file:///Users/raulmelchoryulogarbanzos/Library/Group%20Containers/6N38VWS5BX.ru.keepcoder.Telegram/appstore/account-5097119293733531334/postbox/media/telegram-cloud-photo-size-5-6163672227954929351-y.jpg
uint16_t data = wiringPiI2CReadReg16(adc, 0x00); low = (data & 0xFF00) >> 8; high = (data & 0x00FF) << 8; value = (high | low)>>4; return value; I know this stables the value some how but how and why
uint16_t data = wiringPiI2CReadReg16(adc, 0x00); low = (data & 0xFF00) >> 8; high = (data & 0x00FF) << 8; value = (high | low)>>4; return value; I know this stables the value some how but how and why Please give explanation
You are creating an app that will allow university students to connect with advisors and other students to discuss stressful situations. Only students who attend the university can access the app. Which two steps should you take to protect student’s identity and personal information? (Choose two.) Group of answer choices Hash student data transmissions with a random salt. Hash the password using an algorithm in the Google database Hash the password with a random salt. Encrypt the password. Encrypt student data transmissions.
Create a session variable called SProot and assign the generated positive root value to it in Oroots.php. Display this session variable in PosRoot,php page.
Computer Science Create a session variable called SProot and assign the generated positive root valueto it in Oroots.php. Display this session variable in PosRoot,php page.
can you please explain this code which is written to perform these tasks: The list of projects that each employee worked on. The average award received by each employee. The maximum and minimum monthly awards are received by each employee. The project id and language in which each employee received the maximum award for working on that project. The employee name that received the maximum awards within 10 years. The number of projects that each employee did not work on it. code: import pandas as pd import numpy as np URL = "https://bit.ly/38zhU5T" df=pd.read_csv(URL) arr=df.to_numpy() employee_notworked=[0,0,0,0] #Array to store the number of projects each employee did not work employee=[[]]*4 #list of projects worked by employees. min_award=[0,0,0,0] #Array to store minimum award received by employees. max_award=[0]*4 #Array to store maximum award received by employees. avg_awards=[0]*4 #Array to store the average award received by employees. maxaward_employee=0 project_id=[None]*4…
"""return the haversine distance between the two locations.The location should be a tuple of (latitude, longitude)https://en.wikipedia.org/wiki/Haversine_formulaIf you use code from a website as the basis for this function, besure to document that website here::param location1::param location2::return: haversine distance between two locations, measured in miles.""" FILES LOOK LIKE THISID,City,State,Latitude,LongitudeA45419E,Plattsburgh,NY,44.704021,-73.471148A19312D,Aiken,SC,33.554433,-81.69588A90172S,Tuscaloosa,AL,33.170238,-87.616169A19394D,Alexandria,VA,38.819853,-77.059645A27218D,Pittsburgh,PA,40.47441,-79.950968A68626D,Meadville,PA,41.611599,-80.114891A17494D,Allentown,PA,40.602658,-75.469236A86034S,Tonawanda,NY,42.99704,-78.878659A45142D,Asheville,NC,35.602711,-82.567281A38298S,Atlanta,GA,33.844371,-84.47405A14497Y,Roswell,GA,34.055198,-84.370475A25954D,Austin,TX,30.326374,-97.771258B46374X,Fairhope,AL,30.480713,-87.861306B52199S,Cedar…
Script should 1 t0 10. Correct.
Medical Unlimited Medical Unlimited (the brainchild of a group of young philanthropic medical professionals) is interested in setting up a mobile medical unit that provides free medical services for students. The mobile medical unit will require a patient record and scheduling application that will be used by the medical staff (doctors/nurses) and receptionists working there. The receptionists will use the system to capture new patient information when firsttime patients visit the doctor. Receptionists will also be responsible for scheduling all appointments. Nurses on the other hand will use the s ystem to keep track of the results of each visit including diagnosis, medications, prescription and treatment. Multiple medications may be prescribed during each visit. The nurses can also access the information to print out a history of patient visits. Th e doctors will primarily use the system to view patient history. The doctors may enter some patient treatment information and…