Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
SQL Apartments question
a guest
Feb 16th, 2021
790
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
SQL
0.12 KB
| None
|
0
0
raw
download
clone
embed
print
report
SELECT
*
FROM
Apartments
WHERE
price
>
(
SELECT
AVG
(
price
)
FROM
Apartments
)
AND
'status'
=
'Not rented'
ORDER
BY
price
ASC
;
Advertisement
Add Comment
Please,
Sign In
to add comment
Public Pastes
Untitled
12 min ago | 5.99 KB
Untitled
2 hours ago | 4.73 KB
Untitled
2 hours ago | 1.49 KB
Untitled
4 hours ago | 5.06 KB
Linter warnings for Nix flake
4 hours ago | 2.13 KB
Untitled
6 hours ago | 5.56 KB
Untitled
9 hours ago | 10.53 KB
Untitled
11 hours ago | 17.31 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!