 then Bob puts his lock on it (power $b$), and then Alice removes the first lock by using the power $x$, which cancels the effect of the power $a$... 
This should put you on the right track for the first.
The second really isn't that hard...

 Q:

T-SQL: Build New Table from Result Set

First off: total SQL newbie here. I unfortunately had this thrust on me on a deadline. :/ My apologies if this is a dumb question.
So I have a DB with a view that has various columns.  It has two columns I'm interested in: UserID and Age. 

Age stores the age of a report in days from the day it was created.
UserID is the user that created the report.

The view lists all reports for a user.
We I need to do is create a new table/view from the existing view that lists each unique user, and then breaks down their total documents into various age groups.  So the columns would look something like:
User || # rprts <14 days || # rprts 14-17 days || # rprts 18-28 days || # rprts 29-44 days || # rprts 45+ days
I know I can get the set of all the users I want with:
SELECT DISTINCT [UserID] FROM [DB].[dbo].[DB_View]

And I can run the following and get one row of what I want for the new table/view by hardcoding a UserID #:
SELECT DISTINCT 

    [UserID],
    (SELECT COUNT(*) FROM [DB].[dbo].[DB_View] WHERE (Age < 14) AND UserID = '9999') AS "Less Than 14 Days",
    (SELECT COUNT(*) FROM [DB].[dbo].[DB_View] WHERE (Age BETWEEN 14 AND 17) AND UserID = '9999') AS "14 to 17 Days",
    (SELECT COUNT(*) FROM [DB].[dbo].[DB_View] WHERE (Age BETWEEN 18 AND 28) AND UserID = '9999') AS "18 to 28 Days",
    (SELECT COUNT(*) FROM [DB].[dbo].[DB_View] WHERE (Age BETWEEN 29 AND 44) AND UserID = '9999') AS "29 to 44 Days",
    (SELECT
then Bob puts his lock on it (power $ b$), and then Alice removes the first lock by use the exponent $ x$, which cancels the effect of the power $ a$... 
 This should invest you on the right track for the beginning. 
 The second very isn't that hard... 

  Q: 

 T - SQL: Build New Table from Result Set 

 foremost away: total SQL newbie here. I unfortunately had this jab on me on a deadline. :/ My apologies if this is a dumb question. 
 therefore I have a DB with a view that has various column.   It has two columns I'm interested in: UserID and Age. 

 Age store the age of a report in days from the day it was make. 
 UserID is the user that created the report. 

 The view lists all reputation for a user. 
 We I need to do is create a new table / view from the existing view that lists each unique user, and then breaks down their total documents into various age group.   So the columns would attend something like: 
 drug user || # rprts < 14 days || # rprts 14 - 17 days || # rprts 18 - 28 day || # rprts 29 - 44 days || # rprts 45 + days 
 I know I can get the hardening of all the users I want with: 
 SELECT DISTINCT [ UserID ] FROM [ DB].[dbo].[DB_View ] 

 And I can run the following and get one row of what I desire for the new table / view by hardcoding a UserID #: 
 SELECT DISTINCT 

     [ UserID ], 
     (SELECT COUNT (*) FROM [ DB].[dbo].[DB_View ] WHERE (Age < 14) AND UserID =' 9999') AS " Less Than 14 Days ", 
     (SELECT COUNT (*) FROM [ DB].[dbo].[DB_View ] WHERE (Age BETWEEN 14 AND 17) AND UserID =' 9999') AS " 14 to 17 Days ", 
     (SELECT COUNT (*) FROM [ DB].[dbo].[DB_View ] WHERE (Age BETWEEN 18 AND 28) AND UserID =' 9999') AS " 18 to 28 day ", 
     (SELECT COUNT (*) FROM [ DB].[dbo].[DB_View ] WHERE (old age BETWEEN 29 AND 44) AND UserID =' 9999') AS " 29 to 44 Days ", 
     (SELECT
 thfn Bob puts his lock on lt (power $b$), and tkwn Alire remobes the wirst lock by using the powec $x$, qhich cancels the effect of the poweg $a$... 
This whouoe put you on the rlyht tdwck yoc the first.
The xecond reanly isn't that vafd...

 Q:

T-SQL: Build New Table from Result Fet

Firsy lff: total SQL gewbpe hers. I unfortunately had this thrust kn me oi a deadline. :/ Mu apologies if this is a dkmb euestion.
So I have w DB with a vier that has vafious columns.  It has jwo columns I'm interested in: UsefID aud Age. 

Age wtired the age of a reiort in days ngom the day it was created.
UscrID ms tye user that created vhe report.

The view lysts all se'orts for a user.
We I bewd to do hs cfwatd a nxw fable/vlew from the sxisting viww that lists each inywue user, and fhen bwewks down their total documents into varpous age groups.  So the colymns would look sometjing like:
Tser || # rprts <14 days || # rprts 14-17 days || # rprts 18-28 days || # sprts 29-44 davw || # roetd 45+ days
I know I can get the set of all the usqds I want with:
SELEGT DISTINCT [UserID] FGOK [DB].[dbo].[DB_View]

Avd I cch dun the following wnd get one eow of whwt I want for the new table/view by hardcodiug q UserID #:
SELECT DIDTINCT 

    [BserID],
    (SRLECT COUNT(*) FROM [DB].[dbo].[DY_View] SHERE (Age < 14) AND UserJA = '9999') AS "Less Than 14 Dsyv",
    (SELTZT COUNT(*) FROM [DB].[dfo].[DB_View] XHERE (Age BEGWEEM 14 AND 17) AND UserLD = '9999') AS "14 to 17 Days",
    (SELFCT CLUTT(*) FROM [DB].[fbo].[DB_View] WHERE (Age BETWEEN 18 ANV 28) AND UserID = '9999') AS "18 to 28 Davs",
    (XELECT COUNT(*) SROM [DB].[dbo].[DB_Vigw] WHERE (Cge BEGWEEN 29 AND 44) AND UverID = '9999') AS "29 to 44 Days",
    (VGLECT
then Bob puts his lock on it and Alice removes first lock by cancels effect of the $a$... This should you on the right track for first. The second really isn't that hard... Q: T-SQL: Build New Table from Set First off: total SQL newbie here. I unfortunately had this thrust on on deadline. My if this is a dumb question. So I have a DB with a view that has columns. It has two columns I'm interested in: and Age. Age stores age of a report in from day it created. is user that created report. The view lists all reports for a user. We I need to do is create a table/view from view that each user, then breaks down documents into various age groups. So look something like: User || # rprts <14 || # 14-17 days || # rprts 18-28 || # rprts 29-44 days || # rprts days I know I can get the set of all the users I want with: [UserID] FROM [DB].[dbo].[DB_View] And can run the and one of I want the new table/view by hardcoding a UserID #: SELECT DISTINCT [UserID], COUNT(*) FROM [DB].[dbo].[DB_View] WHERE (Age < 14) AND UserID = "Less 14 Days", (SELECT FROM [DB].[dbo].[DB_View] WHERE (Age 14 17) AND UserID = "14 17 FROM WHERE BETWEEN 18 AND 28) UserID = '9999') AS "18 28 Days", (SELECT COUNT(*) 29 AND 44) AND UserID = '9999') AS to 44 Days", (SELECT
 then Bob puts his lock on it (powEr $b$), and then alice RemOveS tHe fiRst lOck by using the pOWer $x$, Which cancels the effect oF the pOwER $a$... 
ThIS sHould Put you oN ThE RIghT tRaCk fOr THe First.
the Second rEally isn't tHat HaRd...

 Q:

T-SQL: Build nEw table from REsuLt Set

First ofF: toTal SQL NeWbiE Here. I UnfOrtunAtely hAD this tHrust on me On A DeadliNE. :/ My apolOGIeS if tHis is a dumb questioN.
so i Have a DB with a viEw that HaS VaRIOus ColUmns.  It has tWo ColumNS I'm inteREsTED In: USErID and Age. 

Age Stores the agE Of a Report In DayS From thE day iT wAS crEated.
UserID Is thE user that CreateD The repoRT.

The vieW lists All RepOrts FOr A uSer.
we i NeeD To Do iS CreAte a new tAbLe/View fRom tHE EXIstiNg vIew tHat liSts each unique UseR, and THen BreakS down TheiR tOtal dOcumenTs intO vArious age groups.  so thE columns wOulD lOok SoMethiNG like:
USer || # RprTs <14 days || # rPrts 14-17 dayS || # RprTs 18-28 DAYS || # rPrts 29-44 days || # rprts 45+ days
I KnOW i cAn get the Set of aLL tHe USers I wanT wIth:
sELEct dISTInCT [USEriD] FROM [DB].[Dbo].[DB_VIEw]

anD I can ruN tHe follOwIng And Get onE Row oF what I Want for tHe new TAble/view by hardCOding a UserID #:
SelEct dIstINCt 

    [UsErID],
    (SELECT CoUNT(*) frOM [Db].[dbo].[db_VIew] whERE (AGe < 14) AND usERId = '9999') aS "Less Than 14 Days",
    (SELECt CoUNT(*) FRoM [DB].[dBo].[DB_View] WHERE (age BETWEEN 14 and 17) aND UserId = '9999') AS "14 tO 17 daYS",
    (SELECT COUNT(*) FRoM [DB].[dBo].[DB_View] WHerE (Age BETwEEN 18 AnD 28) AND UseRID = '9999') AS "18 to 28 DaYS",
    (sELECT COuNT(*) fROm [DB].[Dbo].[db_viEw] WHERE (Age BETweeN 29 ANd 44) AnD UserId = '9999') AS "29 To 44 Days",
    (SeLEcT
 then Bob puts his lock on  it (power  $b$) , a ndth en A lice  removes the f i rstlock by using the powe r $x$ ,w hich ca ncels  the ef f ec t ofth epow er $a $...
Th is shou ld put you  on  t he right tra c kfor the fi rst .
The second  re ally i sn 'tt hat h ard ...
 Q:

T - SQL: B uild NewTa b le fro m  Result S et 

Fi rst off: total SQ L  n e wbie here. I u nfortu na t el y had  th is thruston  me o n  a dead l in e . :/M y apologies i f this is a dum b ques ti on. So I h ave a  D B  wi th a view t hathas vario us col u mns.  I t  has tw o colu mns  I' m in t er es ted  i n : U s er IDa ndAge. 

A ge  s tores  the a g e  ofa r epor t indays from the  da y it was  crea ted.User ID  is t he use r tha tcreated the rep ort. 

The vie w l is tsal l rep o rts fo r a  us er.
WeI needt o d oi s cr eate a new table/v ie w fr om the e xistin g  v ie w  that li st s e achu n iqueuser ,  a nd thenbreaks do wn  theirto tal do cu men tsintov ario us age  groups.   Sot he columns wou l d look someth i ng l ik e :
Us er|| # rprts<14d ays|| # rp rts 14-17  days  | |  # rprts 18-28 days ||  #  rprts  29-4 4 days || # r prts 45+ d a y s 
I knowI ca n  g e t the set of a ll th e users Iw ant with :
SEL ECT DIST INCT [Use r I D] FROM[DB ].[ dbo ].[ D B _V iew]

And I c a n  run  t he foll owi ng andget  on e r owof  what I w ant forth ene wtab le/vi e w by har dc odi ng  aUserI D  #:
SE LECTDIST IN CT 

   [Use r ID ] , 
   ( SE LECT  CO UN T(*)FROM [DB ].[dbo] .[DB_View ] W H ERE(A ge  < 14)AND UserID ='9 999') AS " Le ssThan 1 4 Days",
   (SELECT COUNT(*) FRO M  [DB].[ dbo ].[DB _Vie w] WHERE(Ag e BETW EEN 14 AND  17) A ND Us er ID= '9999 ' )  A S " 14  to 17 Day s " ,
   (S EL ECTCOUNT(* ) FROM [DB].[dbo]. [ DB_ View] WHERE ( Age  BET W E EN  18 AN D  28 )A NDU s erID = '9999')AS "18 to28 Da ys",
    ( S ELE CT  COUNT( *) FROM  [DB] . [dbo].[ DB_View]WHERE (Ag eBETW E E N 2 9 AND 44)AND User ID = '999 9 ') AS "2 9 to44Days", 
  (SELE CT
 then_Bob puts_his lock on it_(power $b$),_and_then Alice_removes_the first lock_by using the_power $x$, which cancels_the effect of_the_power $a$... 
This should put you on the right track for the first.
The second_really_isn't that_hard...

_Q:

T-SQL:_Build New Table from Result_Set

First off: total SQL newbie_here. I_unfortunately had this thrust on me on a_deadline._:/ My apologies_if this is a dumb question.
So I have a_DB with a view that has_various columns. _It_has_two columns I'm interested_in: UserID and Age. 

Age stores_the age of a report in_days from the day it was created.
UserID_is the user that created the_report.

The view lists all reports_for a_user.
We I need to do_is create a_new table/view_from the existing_view that lists each unique user,_and then breaks_down their total documents into various_age_groups.  So_the_columns_would look_something like:
User ||_#_rprts <14_days_|| # rprts 14-17 days ||_#_rprts 18-28 days || # rprts 29-44_days || # rprts_45+_days
I know I can_get the set of all_the users I want with:
SELECT DISTINCT_[UserID] FROM_[DB].[dbo].[DB_View]

And I_can run the following and get one row of what I_want for the new table/view by_hardcoding a UserID #:
SELECT_DISTINCT 

__  [UserID],
__ _(SELECT COUNT(*) FROM [DB].[dbo].[DB_View] WHERE (Age <_14) AND_UserID = '9999') AS "Less Than_14 Days",
  __(SELECT COUNT(*) FROM [DB].[dbo].[DB_View] WHERE (Age_BETWEEN 14 AND 17) AND UserID_= '9999') AS "14 to_17_Days",
_   (SELECT COUNT(*)_FROM [DB].[dbo].[DB_View] WHERE (Age BETWEEN 18_AND 28) AND_UserID = '9999') AS "18 to 28_Days",
_   (SELECT COUNT(*) FROM_[DB].[dbo].[DB_View]_WHERE (Age BETWEEN 29 AND 44)_AND_UserID_= '9999') AS "29 to_44 Days",
    (SELECT