Skip to content

Chinnumaddimsetti/SQL

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

32 Commits
Add 'MatchesPlayed', 'MatchesWon' columns of type NUMBER to Player table discribed below:
Add 'MatchesPlayed', 'MatchesWon' columns of type NUMBER to Player table discribed below:
 
 
Alter the table Shopper to change the data type of mobile number from NUMBER to VARCHAR2. Mobile number can have a maximum length of 15 characters.
Alter the table Shopper to change the data type of mobile number from NUMBER to VARCHAR2. Mobile number can have a maximum length of 15 characters.
 
 
Create the Address table as per specification below:
Create the Address table as per specification below:
 
 
Create the City table as per the specification.
Create the City table as per the specification.
 
 
Display quotationid, sname, itemcode, quotedprice, qdate, qstatus of those quotations which are not accepted.
Display quotationid, sname, itemcode, quotedprice, qdate, qstatus of those quotations which are not accepted.
 
 
Insert the following data into Article table.
Insert the following data into Article table.
 
 
Insert the following data into Shopper table. Modify the data in case of constraint violation
Insert the following data into Shopper table. Modify the data in case of constraint violation
 
 
Insert the following data into Supplier table created on Day 2.
Insert the following data into Supplier table created on Day 2.
 
 
Modify the Supplier table to store the supplier city. The column name should be City and it can have maximum of 10 characters.
Modify the Supplier table to store the supplier city. The column name should be City and it can have maximum of 10 characters.
 
 
Modify the size of state column in Address table from 5 to 20.
Modify the size of state column in Address table from 5 to 20.
 
 
README.md
README.md
 
 
Remove the Emailid column from Supplier table
Remove the Emailid column from Supplier table
 
 
Retrieve item id, item description and price for items whose names have 'r' as the second character.
Retrieve item id, item description and price for items whose names have 'r' as the second character.
 
 
Retrieve itemcode, description and price for all items.
Retrieve itemcode, description and price for all items.
 
 
Retrieve the designation and salary of all 'Manager' and 'Billing Staff'
Retrieve the designation and salary of all 'Manager' and 'Billing Staff'
 
 
Retrieve the designation and salary of employees without any duplication of data.
Retrieve the designation and salary of employees without any duplication of data.
 
 
Retrieve the itemcode, descr and unit price of the items which have 'Shirt' or 'Skirt' in their desc and their category is 'B'.
Retrieve the itemcode, descr and unit price of the items which have 'Shirt' or 'Skirt' in their desc and their category is 'B'.
 
 
Retrieve the orderid, quotationid and status of those orders where order is placed between the dates '1-Dec-2014' and '1-Jan-2015'
Retrieve the orderid, quotationid and status of those orders where order is placed between the dates '1-Dec-2014' and '1-Jan-2015'
 
 
Retrieve the quotation id and sname of the quotations which have been either 'Accepted' or 'Rejected'.
Retrieve the quotation id and sname of the quotations which have been either 'Accepted' or 'Rejected'.
 
 
Retrieve the roid and location which does not have a Manager.
Retrieve the roid and location which does not have a Manager.
 
 
The following assignments are to be completed in the Eclipse Environment.Display descr and price of different sizes of all 'Hard disk'.
The following assignments are to be completed in the Eclipse Environment.Display descr and price of different sizes of all 'Hard disk'.
 
 
Write a query to display product id, description, category and discount of all Apparel products from the Product table.
Write a query to display product id, description, category and discount of all Apparel products from the Product table.
 
 
Write a query to display product id, description, category and discount of all Apparel products that have discount more than 5 percent.
Write a query to display product id, description, category and discount of all Apparel products that have discount more than 5 percent.
 
 
Write a query to display product id, description, category and discount of all products that do not have any description.
Write a query to display product id, description, category and discount of all products that do not have any description.
 
 
player1 not equal to player2
player1 not equal to player2
 
 

Repository files navigation

SQL

Create Match table as per details below. A player cannot play against himself, so player1 should not be equal to player2.

About

Create Match table as per details below. A player cannot play against himself, so player1 should not be equal to player2.

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

 
 
 

Contributors