sql
You have the following table:
number, where, income
1,NJ,35
1,Col,42
1,LA,29
1,Pa,37
2,NJ,33
2,Col,41
2,LA,31
2,Pa,36
Write SQL query to output:
1, 2
143, 141
Write SQL query to output:
NJ, Col, LA, Pa
68,83,60,73
sql You have the following table: number, where, income 1,NJ,35 1,Col,42 1,LA,29 1,Pa,37 2,NJ,33 2,Col,41 2,LA,31 2,Pa,3
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
sql You have the following table: number, where, income 1,NJ,35 1,Col,42 1,LA,29 1,Pa,37 2,NJ,33 2,Col,41 2,LA,31 2,Pa,3
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!