Interactive POS Demo

Task: Verify the Statement against the Table

Statement: ngc 2082 redshift faster than ngc 1705 by 551 kilometers per second plus or minus 6 kilometers per second

Table: dorado group

name	type	ra___j2000__	dec___j2000__	redshift__km___s__	apparent_magnitude
ngc 2082	sab (rs + ) c	05h41 m51.1s	degree18′04″	1184 ± 6	12.6
ngc 1947	s0 - pec	05h26 m47.6s	degree45′36″	1100 ± 24	11.7
ngc 1796	(r) sb (r) dm :	05h02 m42.5s	degree08′24″	1014 ± 9	12.9
ngc 1688	sb (rs) dm	04h48 m23.8s	degree48′01″	1228 ± 6	12.6
ngc 1672	(r'_1: ) sb (r) bc sy2	04h45 m42.5s	degree14′50″	1331 ± 3	10.3
ic 2056	sab (r) b	04h16 m24.5s	degree12′25″	1133 ± 10	12.5
ngc 1559	sb (s) cd	04h17 m35.8s	degree47′01″	1304 ± 4	11.0
ngc 1543	(r) sb (l) 0 0	04h12 m43.2s	degree44′17″	1176 ± 7	11.5
ngc 1574	sa0 -	04h21 m58.8s	degree58′29″	1050 ± 25	11.4
ngc 1533	(l) sb (rs) 0 0	04h09 m51.8s	degree07′06″	790 ± 5	11.7
ngc 1546	sa0 +	04h14 m36.5s	degree03′39″	1284 ± 14	11.8
ngc 1553	sa (rl) 0 0	04h16 m10.5s	degree46′49″	1080 ± 11	10.3
ngc 1549	e0 1	04h15 m45.1s	degree35′32″	1220 ± 15	10.7
ngc 1566	(r'_1) sab (rs) bcsy1	04h20 m00.4s	degree56′16″	1504 ± 2	10.3
ngc 1617	(r') sab (rs) a	04h31 m39.5s	degree36′08″	1063 ± 21	11.4
ngc 1515	sab (s) bc	04h04 m02.7s	degree06′00″	1175 ± 7	12.1
ngc 1705	sa0 - pec	04h54 m13.5s	degree21′40″	633 ± 6	12.8
ngc 1596	sa0: sp	04h27 m38.1s	degree01′40″	1510 ± 8	12.1

Generating plan to answer the query...

Generated steps

Step 1: Select rows where 'name' is 'ngc 2082' or 'ngc 1705'.

Step 2: Extract the numerical value from the 'redshift__km___s__' column then add column 'redshift' to existing table.

Step 3: Select rows where 'name' is 'ngc 2082' and 'redshift' is greater than the redshift value of 'ngc 1705'.

Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.

Step 1: Select rows where 'name' is 'ngc 2082' or 'ngc 1705'.

SQL command for the step:

SELECT * FROM table_sql WHERE name IN ('ngc 2082', 'ngc 1705');

name	type	ra___j2000__	dec___j2000__	redshift__km___s__	apparent_magnitude
ngc 2082	sab (rs + ) c	05h41 m51.1s	degree18′04″	1184 ± 6	12.6
ngc 1947	s0 - pec	05h26 m47.6s	degree45′36″	1100 ± 24	11.7
ngc 1796	(r) sb (r) dm :	05h02 m42.5s	degree08′24″	1014 ± 9	12.9
ngc 1688	sb (rs) dm	04h48 m23.8s	degree48′01″	1228 ± 6	12.6
ngc 1672	(r'_1: ) sb (r) bc sy2	04h45 m42.5s	degree14′50″	1331 ± 3	10.3
ic 2056	sab (r) b	04h16 m24.5s	degree12′25″	1133 ± 10	12.5
ngc 1559	sb (s) cd	04h17 m35.8s	degree47′01″	1304 ± 4	11.0
ngc 1543	(r) sb (l) 0 0	04h12 m43.2s	degree44′17″	1176 ± 7	11.5
ngc 1574	sa0 -	04h21 m58.8s	degree58′29″	1050 ± 25	11.4
ngc 1533	(l) sb (rs) 0 0	04h09 m51.8s	degree07′06″	790 ± 5	11.7
ngc 1546	sa0 +	04h14 m36.5s	degree03′39″	1284 ± 14	11.8
ngc 1553	sa (rl) 0 0	04h16 m10.5s	degree46′49″	1080 ± 11	10.3
ngc 1549	e0 1	04h15 m45.1s	degree35′32″	1220 ± 15	10.7
ngc 1566	(r'_1) sab (rs) bcsy1	04h20 m00.4s	degree56′16″	1504 ± 2	10.3
ngc 1617	(r') sab (rs) a	04h31 m39.5s	degree36′08″	1063 ± 21	11.4
ngc 1515	sab (s) bc	04h04 m02.7s	degree06′00″	1175 ± 7	12.1
ngc 1705	sa0 - pec	04h54 m13.5s	degree21′40″	633 ± 6	12.8
ngc 1596	sa0: sp	04h27 m38.1s	degree01′40″	1510 ± 8	12.1

Step 2: Extract the numerical value from the 'redshiftkm_s__' column then add column 'redshift' to existing table.

SQL command for the step:

ALTER TABLE table_sql ADD COLUMN redshift NUMERIC; UPDATE table_sql SET redshift = CAST(redshift__km___s__ AS NUMERIC);

name	type	ra___j2000__	dec___j2000__	redshift__km___s__	apparent_magnitude
ngc 2082	sab (rs + ) c	05h41 m51.1s	degree18′04″	1184 ± 6	12.6
ngc 1705	sa0 - pec	04h54 m13.5s	degree21′40″	633 ± 6	12.8

Step 3: Select rows where 'name' is 'ngc 2082' and 'redshift' is greater than the redshift value of 'ngc 1705'.

SQL command for the step:

SELECT * FROM table_sql WHERE name = 'ngc 2082' AND redshift > (SELECT redshift FROM table_sql WHERE name = 'ngc 1705');

name	type	ra___j2000__	dec___j2000__	redshift__km___s__	apparent_magnitude	redshift
ngc 2082	sab (rs + ) c	05h41 m51.1s	degree18′04″	1184 ± 6	12.6	1184.0
ngc 1705	sa0 - pec	04h54 m13.5s	degree21′40″	633 ± 6	12.8	633.0

Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.

SQL command for the step:

SELECT CASE WHEN COUNT(*) = 1 THEN TRUE ELSE FALSE END AS verification FROM table_sql;

name	type	ra___j2000__	dec___j2000__	redshift__km___s__	apparent_magnitude	redshift
ngc 2082	sab (rs + ) c	05h41 m51.1s	degree18′04″	1184 ± 6	12.6	1184.0

Verification:

The statement is TRUE