FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
sqlcheck/examples/query4.sql at master · bitsoex/sqlcheck · GitHub
This repository was archived by the owner on Mar 31, 2026. It is now read-only.
bitsoex
/
sqlcheck
Public archive
Notifications
You must be signed in to change notification settings
Fork
1
Star
0
Code
Issues
0
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
sqlcheck
/
examples
/
query4.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
21 lines (21 loc) · 335 Bytes
Breadcrumbs
sqlcheck
/
examples
/
query4.sql
Copy path
File metadata and controls
21 lines (21 loc) · 335 Bytes
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
select
o_orderpriority,
count
(
*
)
as
order_count
from
orders
where
o_orderdate
>=
date
'
1994-08-01
'
and
o_orderdate
<
date
'
1994-08-01
'
+
interval
'
3
'
month
and
exists (
select
*
from
lineitem
where
l_orderkey
=
o_orderkey
and
l_commitdate
<
l_receiptdate
)
group by
o_orderpriority
order by
o_orderpriority;
Back
|
FazBrowse Home
|
New Git URL