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
- TBE103/03: Environmental Science and Design Report, WOU, Malaysia Green and sustainable development is globally promoted, and “Go Green” initiatives are also widely being encouraged in the country
- SKMM2413: Thermodynamics Assignment, UMT, Malaysia Choose a value for the polytropic exponent between 1.2-1.6. Using Microsoft Excel, construct the process
- MBA7233 Managerial Business Analytics Assignment 1 Brief | JUC Malaysia
- INF20003: Requirements Analysis and Modelling Case Study, SUT, Malaysia Whirlwind Courier Services As an employee of a large international courier and shipping service, Mike Morten met
- BNRS 6214: Introduction to Research Methodology $ Statistic for Nurses Assignment, LUC, Malaysia The student is required to write a quantitative research proposal about any topic of interest
- Practical IT Skill Course Work, NUN, Malaysia MacroHard Corporation has initiated a competition that gives the opportunity to new small and medium entrepreneurs
- Early Childhood Education Assignment, UIU, Malaysia You are required to design an integrated pedagogical approach for five-year-old children
- NBHS1213: Anatomy and Physiology 2 Assignment, OUM, Malaysia Discuss the urinary system and its components from the perspective of anatomy and physiology
- STA404: Statistics for Business and Social Sciences Assignment, UiTM, Malaysia The depression scores of 25 patients were recorded before and after they had undergone therapy
- ACC4294: Effective Governance Report, UH, Malaysia Today’s environment is one not only of heightened risk but of prolonged uncertainty
