SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 26 Mar 2018 My Price 10.00

single-row functions from each of the categories

Five additional queries that use single-row functions from each of the categories listed below. In addition to the query, explain what the query is meant to do as part of a SQL comment prior to the query:

  1. Character Function.
  2. Numeric Function.
  3. DateTime Function.
  4. Conversion Function.
  5. NVL Function (you may need to remove data to make this work).

 

--ques 1
select custNo, custfirstname ||custlastname,custcity, custstate,custzip
from customer
order by custfirstname,custlastname;
 
--ques 2
select OrdNo,to_char(OrdDate, 'yyyy-mm-dd hh24:mi:ss') order_date , CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  OrdState, OrdZip
  from ORDERS;
  
--ques 3
SELECT ProdNo, INITCAP(ProdName), ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice
from product;
--ques 4
Select ordNo, CustNo,Orddate, OrdName
from orders 
where EXTRACT(month FROM ORDDATE)=2;
 
--ques 5
Select ProdNo, ProdNo, ROUND(ProdPrice)
from Product;
--ques 6
Select OrdNo, (qty*product.ProdPrice) as Total_Price
from Order_Line, Product
where Order_Line.PRODNO=Product.PRODNO;
 
--ques 7
Select * from
customer
where custfirstname like 'B%';
 
--ques 8
Select * from product
where ProdPrice>10;

 

 

Answers

SophiaPretty
(5)
Status NEW Posted 26 Mar 2018 02:03 PM My Price 10.00

  ----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------  ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------

Not Rated(0)
Relevent Questions