SELECT RunNumber, EventNumber, LooseElectronPt1 FROM streamtest_inclEle WHERE abs(LooseElectronPt1) > 25000
Try this query? Click here:
Plot as a histogram? (Thanks, Julius.) Click here

Note 1: Because not every event with a 25-GeV electron passes the L2_e25i trigger, this query must really be addressed to all streams. (To avoid duplicates, exclusive streams are useful here.)

Note 2: The correctness of this solution relies upon two assumptions about the code that fills the tags:

1. that LooseElectronPt[1-4] are filled in descending order of ABS(pt);
2. that LooseElectronPt1 is set to 0 when there are no electrons.

If the latter is not true, then the where clause must include a check on NLooseElectron, e.g.,

WHERE NLooseElectron > 0 AND ABS(LooseElectronPt1) > 25000

Question to database optimizers: Is Oracle's query plan the same whether we use

WHERE ABS(LooseElectronPt1)>25000 

or 

WHERE LooseElectronPt1 > 25000 OR LooseElectronPt1 < -25000?

Q2. ...every event that passed the 25 GeV electron trigger.

A2.

SELECT RunNumber, EventNumber, LooseElectronPt1 FROM streamtest_inclEle WHERE L2_e25i=1
Try this query? Click here:

Note: Surprisingly enough, it turns out that it is not true that every event that passed the 25-GeV electron trigger made it into the inclusive electron stream. An all-streams query is needed to discover this, and to recover the events missing from the inclusive electron stream. Again, exclusive streams are helpful here.

Q3....every event with a 25 GeV electron that failed the 25 GeV electron trigger.

SELECT RunNumber, EventNumber, LooseElectronPt1 FROM streamtest_inclEle WHERE ABS(LooseElectronPt1) > 25000 AND L2_e25i=0
Try this query? Click here:

Note 1: This is another query that requires selection across all streams, though we illustrate it with the simpler query of the inclusive electron stream alone.

Note 2: in general, we need to AND this selection predicate with a check whether L2_e25i is active. In the streaming tests, this is not an issue, because the same trigger menu was used for all runs. We should return to these exercises when we have a design for checking run-level or {run, lumi block}-level tables for active triggers.

Q4....every event with a 25 GeV electron that passed a trigger other than the 25 GeV electron trigger.

A4.

Note that this is not the same as Q3: we must add to the result set of Q3 the events that satisfied L2_e25i and another trigger at the same time.

SELECT RunNumber, EventNumber, LooseElectronPt1 FROM streamtest_inclEle WHERE ABS(LooseElectronPt1) > 25000 AND ( L2_B35=1 OR L2_E15IL2_E15I=1 OR L2_E60=1 OR L2_G20IL2_G20I=1 OR L2_G60=1 OR L2_JET120L2_JET120=1 OR L2_JET170=1 OR L2_JET25=1 OR L2_JET300=1 OR L2_JET45=1 OR L2_JET50=1 OR L2_JET50L2_JET50L2_JET50L2_JET=1 OR L2_JET550=1 OR L2_JET65L2_JET65L2_JET65=1 OR L2_JET70=1 OR L2_JET90=1 OR L2_MU20I=1 OR L2_MU6=1 OR L2_TAU35I=1 )
Try this query? Click here:

Note 1: This kind of operation ("any trigger other than xxx") should become a bit easier with bit representations, in that checking whether L2_TriggerDecisionWordN is greater than 0 checks 32 bits simultaneously.

Note 2: Again, this is an all-streams query, for which exclusive streaming would be helpful.

Q5. ...every event with two leptons (electrons or muons) with pT > 25 GeV and the same charge.

A5.

Try this query? Click here:

Deferred (...another all-streams query...)

Q6. ...every event with one good electron (> 25 GeV) and either another electron with the opposite charge and pT > 25 GeV or a photon with pT > 25 GeV.

A6.

SELECT RunNumber, EventNumber, LooseElectronPt1 FROM streamtest_inclEle WHERE ABS(LooseElectronPt1)>25000 AND ( ABS(LoosePhotonPt1)>25000 OR ( ABS(LooseElectronPt2)>25000 AND ABS(SIGN(LooseElectronPt1)+SIGN(LooseElectronPt2))<2 ) OR ( ABS(LooseElectronPt3)>25000 AND ABS(SIGN(LooseElectronPt1)+SIGN(LooseElectronPt2)+SIGN(LooseElectronPt3))<3 ) OR ( ABS(LooseElectronPt4)>25000 AND ABS(SIGN(LooseElectronPt1)+SIGN(LooseElectronPt2)+SIGN(LooseElectronPt3)+SIGN(LooseElectronPt4))<4 ) )
Try this query? Click here:

The above is yet another all-streams query, illustrated on the inclusive electron stream.

Q7. ...every event with a 25 GeV muon, at least 25 GeV of missing ET (corrected for the muon), on the good run list, and recorded between April and June.

A7.

select RunNumber, LumiBlockN, EventNumber, LooseMuonPt1, MissingET from streamtest_exclMuo where ABS(LooseMuonPt1)>25000 and ABS(MissingET)>25000 and EXISTS (select lbn from RUN_LBNS where RunNumber=RUN_NUMBER AND LumiBlockN=LBN AND QUALITY LIKE 'green%')
Try this query? Click here:

This is a first-level selection. I omitted the April-June part (streams test data were all April-June, but at worst it is conceptually no different than the quality check. I doubt that there is sufficient information in the tags to correct the missing ET for the muon.

Q8. ...every event with 3 leptons above 25 GeV, with either the two same sign leptons above 30 GeV or with 50 GeV of missing ET.

A8.

Try this query? Click here:

This is doable, but painful, in SQL.

Q9. ...every event with at least one b-jet and at least one lepton (pT > 10 GeV) such that the lepton is within 15 degrees of the jet axis.

Try this query? Click here:

Deferred.

Q10. ...the five events with the largest missing ET.

A10.

select * from (select RunNumber, EventNumber, MissingET from streamtest_inclTau order by MissingET desc) where rownum < 6
Try this query? Click here:

This solution could be needlessly expensive if Oracle's query execution plan is naive.

Q11. ...the five events with exactly two jets and the largest difference in ET between the two jets.

A11.

select * from (select RunNumber, EventNumber, JetPt1, JetPt2, (abs(JetPt1)-abs(JetPt2)) JetPtDifference from streamtest_inclJet where NJet=2 order by JetPtDifference desc) where rownum < 6
Try this query? Click here:

I am using JetPt, not JetEt, here, because that is what is in the tags.