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
- GSGM7334: Project Management Assignment, UIU, Malaysia The CIO of A&D High Tech, Matt Webb, needs to determine whether the proposed online store project can be completed in time
- ABCR2103: Discuss the following questions in the forum and submit proof of your participation in the online discussions: Principles Of Corporate Communication Assignment, OUM, Malaysia
- SCB23302: Fundamentals of Materials Science Assignment, UniKL, Malaysia Using online resources as your reference material, prepare a comprehensive assignment discussing various aspects
- Certified Financial Planner Assignment, UTAR, Malaysia Some weeks ago, you (Danny Lim) a Certified Financial Planner (CFP) and a licensed Financial Planner met your old friend
- BBPS4103: Strategic Management Assignment, OUM, Malaysia Conduct an internal analysis for Apollo Food Holdings Berhad and an external analysis for the industry related to the company.
- PSY231: Evolutionary Psychology Essay, MUM, Malaysia You are required to select one topic or issue from any area of psychology, and explain how the issue can be viewed from an evolutionary psychology perspective
- MBOC7033 International Marketing Management Task Description Individual Assignment and Case study
- CL101 Murder Case Analysis: Evidential Issues & Legal Solutions in PP v Kim & Leo – Section 302 Penal Code
- MBOC 7013: Financial Management Assignment, IUMW, Malaysia You are the Chief Investment Officer of an International Investment Firm
- Enterprise Resource Planning Course Work, MMU, Malaysia Beantown Bikes is satisfied with the quotation and agreed to the terms and conditions of the sale
