Write SQL queries to answer the following questions. Use the information given in each table: Database Assignment, IIU, Malaysia
| University | INTI International University (IIU) |
| Subject | Database Assignment |
1. Write SQL queries to answer the following questions. Use the information given in each table.
a) List the customer details who has a balance of more than 300.
b) List the customer’s name, area code, and invoice number of all customers. Sort the answer in descending order by customer name.
C) List the male customer details whose name starts with the letter
d) Find the number of male customers and display the column name as ‘Total
e) Find the minimum, maximum, average, and number of customers for each area code.
f) Change the balance for Siti to 500.
g) Find the name of a customer who lives in the same area as Diana.
2. Consider the structure of the following PRODUCT table.
a) Write the SQL command to create a new table called PRODUCT based on the information given in Table 1 below.
b) Change the field length of the description to VARCHAR(30) in the PRODUCT table.
c) Add a price column in between description and code in the PRODUCT table. This column only allows floating number data to be entered with a maximum precision of 3 digits and a scale of 2 digits.
d) Rename column description to in the PRODUCT table. This column only
allows variable character data to be entered with a maximum of 30 characters.
Get Help By Expert
Need help with your Data Assignment in Malaysia? Look to our assignment helper Malaysia service, where Malaysian students can conveniently pay someone to do my assignment and receive personalized support. Our team of experts is adept at handling various data-related tasks, including analysis, modelling, and programming.
Recent Solved Questions
- You are planning for your financial retirement. You want to retire at 60. You plan to have an endowment fund that will give you a monthly income of RM 10,000 per month after retirement: Financial Management Assignment, UTP, Malaysia
- Electronics & Electrical Power and Machines Assignment, SU, Malaysia You are required to select any one of the DC OR AC machines. Discuss in detail the construction, working principles
- Government Policy Assignment, UCSI, Malaysia Discuss and criticize the incorporation of sustainable development goals (SDGs) into the education system
- MPU3412: Aktiviti khidmat masyarakat adalah bertujuan untuk meningkatkan kehidupan rakyat supaya mereka: Community Service Assignment, OUM, Malaysia
- Psychology Course Work, UM, Malaysia Google is one of the most well-known brands in the world. Starting with the development of a search engine so effective
- Management Information System Assignment, AU, Malaysia Identify and elaborate on what is a competitive advantage that a company may look for through Industry
- Entrepreneurship Assignment, TU, Malaysia ‘Gardeners love this crap: That’s the slogan for Pierce Ledbetter’s Memphis, Tennessee-based company, Zoo Doo
- CTU231: Motorcar Pro was a business that focusing on selling various of automative car parts and related accessories: Assignment, UiTm, Malaysia
- Anatomy & Physiology Essay, IIUM, Malaysia Discuss the mechanism of the skeletal and muscular systems as well as elaborate on the importance
- Training and Development Assignment: Training Diagnosis and Learning Theory Application
