What's that Symbol
What is the symbol for all
*
Select * from leas where BLDGID = 356
Return all leases that have are at 356 / Silverton
Select * leas where BLDG = '550'
Missing the from
What is the tenant name where the lease ID is HO2629
LUCKY LINE PRODUCTS, INC.
What is a Primary Key
A primary key is the unique identifier for the row within a table
What is the wildcard Symbol
%
select * from journal where source in ( 'AB', 'HJ')
Return all journal entries in open period created by Alex and Heather
select acctnum from GHIST where period = 202101
Table name is incorrect. Should be GHIS
How many journal entry lines did Carly (CH) post in January 2021?
200
What is the difference between the GHIS and Journal tables
GHIS is for closed period data whereas Journal is for open periods (current and future)
What is the symbol for greater or equal to
>=
Select * from GHIS where period = 202107 and source = 'AB' and descrpn like '%entrata%'
return all journal entries from July 2021 posted by Alex and description contained entrata
select cmrecc.BLDGID, cmrecc.leasid, occpname, amount, inccat, effdate from cmrecc join leas on cmrecc.leasid = leas.leasid where inccat = FRE' and effdate = '8/1/21'
Missing apostrophe at FRE
How much rent revenue (MR4000) was budgeted at entity 355 for February 2019
117,630.11
What do we write when we only want empty cells
Select * from ___ where ___ is null
What is the symbol for not equal to?
<>
select * from budgets where period between 202101 and 202106 and acctnum = 'MR5500000' and entityid = 205
Return budgeted amounts for GL MR5500000 between Jan and June 2021
SELECT REF, source acctnum, SUM(AMT) FROM JOURNAL where acctnum like '%1010000%' GROUP BY REF, SOURCE, acctnum order by ref
Missing comma between source and acctnum
How many tenants have abated (FRE) rent on January 1st next year
11
What does joining two tables allow you to do
retrieve data from 2 tables with a common elemen