Question: Database SQL, Using the BANK database write and execute the following SQL statements: 1. Change all CITY to Uppercase. 2. Display the customer number followed

Database SQL,

Using the BANK database write and execute the following SQL statements: 1. Change all CITY to Uppercase. 2. Display the customer number followed by fname followed by 'has card number' followed by card_no. 3. Display the value ' 595.5416 ' rounded to 1,0,1, and 2 decimal places. 4. Display Acc_Type in lowercase. 5. Display the current date in this format (2022-08-16). 6. Change all accounts balances that have zero value to null. 7. Display all information from the accounts table after adding 100 to all account balances. 8. By using the name " Ramiz Ahmed Al-Masry ", print the last part of the name. Note: You must use substr, instr, and trim function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using the BANK database write and execute the following SQL queries: 1. Write a query in SQL to display the customer_name(fname, Iname) whose acc_status is "Active". 2. Write a query in SQL to...

Step 1 From the Windows start menu click on SQL Server Management Studio. Step 2 Login to the database server. On campus enter the following: For server type select Database Engine (which should be...

Before beginning this lab, run the following script in the SQL Server query window. If you have already created a database called hourglass, be sure to drop the database before running these queries....

Universal Furniture Outlet Universal Furniture Outlet (UFO) sells quality furniture for home and office use. Its sales representatives use the attached form to take orders. Customer account numbers...

Using SQL Developer execute the following queries with these statements. N eed help with the joining clauses in SQL. PLEASE help Write a query to display the title, publisher name, and author FROM...

Create a new database and execute the code below in SQL Server's query window to create the database tables, CREATE TABLE Physician Specialties (Specialty.In integer, SpesialtyName varchar(5e),...

Assignment 1: Setting up Databases (15%) This assignment relates to the following Cowrse Learning Requirements: CLR 1 - Plan, Prepare, Install, Configure, and Use a market-leading Database Management...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Blu Power produces a single product and has a budgeted capacity of 3,500 units monthly. At the start of December 2021, there were 650 units of the product in stock. During the month, the company sold...

A coin-operated coffee machine made by BIG Corporation was designed to discharge a mean of 7.1 ounces of coffee per cup. If it dispenses more than that on average, the corporation may lose money, and...

What type of profits is a company's shareholder entitled to if and when the profits are distributed? Interest Growth Dividends Coupons

3 pts D Question 4 Table Cost.EX2: Costs and Outputs for a Competitive Firm Total Total Output Fixed Variable lol Costs Costs 0 $100.00 $0.00 1 $100,00 $70,00 2 $100.00 $120.00 3 $10000 $150.00 4...

2. Go to www.workingmother.com, the Web site for Working Mother magazine. Review any five of the 2008 100 Best Companies for work-life policies. What common practices do they use to help employees...

1. Interview a relative or friend who is currently employed. The interview should a. Identify her current career development stage. b. Identify a special career management challenge she faces. c....

7. How could you help downsized survivors remain motivated and productive? Rank your recommendations in order of importance. Provide a rationale for your ranking.