Sign In
Not register? Register Now!
Essay Available:
You are here: HomeCourseworkIT & Computer Science
Pages:
5 pages/≈1375 words
Sources:
No Sources
Level:
APA
Subject:
IT & Computer Science
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 32.4
Topic:

Structured Query Language IT & Computer Science Coursework (Coursework Sample)

Instructions:

The task was about developing a database after which i was required to answer the questions as listed. the question were about QUERYING specific data from the database.

source..
Content:


SQL Questions
Institution Affiliation
Date
Questions
1 Provide a listing of the novelty goods suppliers, indicated by a supplier category 2. Display supplier ID, supplier name and supplier category. Show the suppliers in alphabetical order by name. Use Purchasing.Suppliers table. Record the number of rows in resulting query: __6_
select SupplierID,SupplierName,SupplierCategoryID from Purchasing.Suppliers where SupplierCategoryID='2' order by SupplierName asc
2 Provide a listing of all suppliers who use a bank in San Francisco (hint: look at BankAccountBranch field). Display supplier ID, supplier name, bank account name and bank account branch. Show the companies in alphabetical order by name. Use Purchasing.Suppliers table. Record the number of rows in resulting query: ______2_______
select SupplierID,SupplierName,BankAccountName,BankAccountBranch from Purchasing.Suppliers where BankAccountBranch like '%San Francisco' order by SupplierName asc
3 Provide a listing of products that are heavier than 1 pound and have a unit price between 15 and 20 dollars. Display stock item ID, stock item name, size, unit price and typical weight per unit. Show the heaviest product first. Use Warehouse.StockItems table. Record the number of rows in resulting query: ______3_______

...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

Other Topics:

  • Course Reflection IT & Computer Science Coursework
    Description: In this week's course, reflection is based on our central learning on information technology importance in strategic planning; a lot was learned and above all, the course was exciting and interactive. The course focuses majorly on the information technology leader’s collaborative roles...
    2 pages/≈550 words| 1 Source | APA | IT & Computer Science | Coursework |
  • Syse650 Exam Questions It & Computer Science Coursework
    Description: In systems engineering, Maintainability can be stated as the comparatively easiness and efficiency in time and energy that a system can withstand or reinstate to a particular circumstance by employing scheduled and unplanned maintenance. Maintenance is a task of architectural system design;...
    4 pages/≈1100 words| 2 Sources | APA | IT & Computer Science | Coursework |
  • Information Security IT & Computer Science Coursework
    Description: The Iconcepts Iof Iconfidentiality, Iintegrity Iand Iavailability Ioccur Ias Ikey Iprinciples Iof Idata Isecurity. IConfidentiality Iexamines Ithe Iprevention Iof Idata Idisclosure Ito Iunauthorized Isystems Ior Ipersons I(Gollmann, I2011). IFor Ian IATM, Ithe Itransaction Iwould Iinvolve Ithe Iphysical...
    6 pages/≈1650 words| 3 Sources | APA | IT & Computer Science | Coursework |
Need a Custom Essay Written?
First time 15% Discount!