Task 3: List the customer ID, first and last names, and balance for all customers. The balance should be rounded to the nearest dollar. CUST IDFIRST NAMELAST_NAMEADDRESSCITYSTATEPOSTALEMAILBALANCECREDIT_LIMITREP_ID125JoeySmith17 Fourth StCodyWY82414jsmith17@example.com80.68500.0005182BillyRufton21 Simple CirGarlandWY82435billyruff@example.com43.13750.0010227SandraPincher53 Verde LnPowellWY82440spinch2@example.com156.38500.0015294SamanthaSmith14 Rock LnRalstonWY82440ssmith5@example.com58.60500.0010314TomRascal1 Rascal Farm RdCodyWY82414trascal3@example.com17.25250.0015375MelanieJackson42 Blackwater WayElk ButteWY82433mjackson5@example.com252.25250.0005435JamesGonzalez16 Rockway RdWapitiWY82450jgonzo@example.com230,401000.0015492ElmerJackson22 Jackson Farm RdGarlandWY82435ejackson4@example.com45.20500.0010543AngieHendricks27 Locklear LnPowellWY82440ahendricks7@example.com315.00750.0005616SallyCruz199 18th AveRalstonWY82440scruz5@example.com8.33500.0015721LeslieSmith123 Sheepland RdElk ButteWY82433Ismith12@example.com166.651000.0010795RandyBlacksmith75 Stream RdCodyWY82414rblacksmith6@example.com61.50500.0005

round()- used to round the values to the nearest integer

Answered: Task 3: List the customer ID, first and…

Task 3: List the customer ID, first and last names, and balance for all customers. The balance should be rounded to the nearest dollar.

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

Similar questions

Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
Task 3: StayWell is offering a monthly discount for residents who pay their rent on a quarterly basis. The discount is 1.75 percent of the monthly fee. For each property, list the office number, address, owner number, owner’s last name, monthly rent, and discount as DISCOUNT. The discount should be rounded to the nearest dollar.
Task 7: List the square footage, owner number, owner last name, and owner first name for each property managed by the StayWell-Columbia City office. Task 8: Repeat Task 7, but this time include only those properties with three bedrooms. Task 9: List the office number, address, and monthly rent for properties whose owners live in Washington State or own two-bedroom properties. Task 10: List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two-bedroom property.
E MyS Mura 04- S Visu: Blac 9 Sign N Hom MyS y goog y! Exer SN c.blackboard.com/ultra/courses/_207342_1/cl/outline Completion Your answers are saved automatically. * Question Completion Status: QUESTION 1 Exercise: Create a statement that will make a copy of the vendors table. The name of the copy should be vendors QUESTION 2 Exercise: Create a statement that will delete the vendors archive table you created in the previous exercise. QUESTION 3 Exercise: Create a statement that will add the following row to the vendor_contact table Click Save and Submit to save and submit. Click Save All Answers to save all answers.
Determine the kind of books that are currently in stock. Each category should be represented by a single item.
Question 13: Evaluate ACE16 +102 10 and show the answer in octal form.
For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.
The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name and height for only horses that have an above average height. Order the results by height (ascending).
The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name and height for only horses that have an above average height. Order the results by height (ascending). Hint: Use a subquery to find the average height.
If a column value is NULL, would you consider the column to be 0 or blank (" ")?
Find out what kind of books are currently accessible in the library's collection. Each category should only have one entry.
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)