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
Posted: Thu Jul 14, 2022 2:28 pm
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: (transpose)
1, 2
143, 141
Write SQL query to output:
NJ, Col, LA, Pa
68,83,60,73
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: (transpose)
1, 2
143, 141
Write SQL query to output:
NJ, Col, LA, Pa
68,83,60,73