Use the following table to answer the question below:Table name: CustomersColumn NameRoleData TypeLengthConstraintcustomerIDstores the ID of a customerChar5Primary keycustFNamestores the first name of a customerVarchar235Cannot be nullcustLNameStores the last name of a customerVarchar235Cannot be nullcustGenderStore the gender of a customerChar1It should be ‘M’ or ‘F’custDOBStores the date of birth of a customerDate custIncomeStore the income of a customerNumber4 Write a SQL query that displays the number of customers who born on the 16th day of a month . Write in SQL a query that displays the ids of the customers who have the highest income . Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials .

1. select count(customerID) from Customers where to_char(custDOB,'DD') = 16; 2. select customerID…

Answered: Write a SQL query that displays the…

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

Related questions

Concept explainers

Question

Use the following table to answer the question below:

Table name: Customers
Column Name	Role	Data Type	Length	Constraint
customerID	stores the ID of a customer	Char	5	Primary key
custFName	stores the first name of a customer	Varchar2	35	Cannot be null
custLName	Stores the last name of a customer	Varchar2	35	Cannot be null
custGender	Store the gender of a customer	Char	1	It should be ‘M’ or ‘F’
custDOB	Stores the date of birth of a customer	Date
custIncome	Store the income of a customer	Number	4

Write a SQL query that displays the number of customers who born on the 16^th day of a month .
Write in SQL a query that displays the ids of the customers who have the highest income .
Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials .

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions