analysis

40 rows where family = 073

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ name family
0730013101 MA Strategy Basic 2011 MA Strategy 073
0730013202 MA Strategy Basic 2012 MA Strategy 073
0730013302 MA Strategy Basic 2013 MA Strategy 073
0730013402 MA Strategy Basic 2014 MA Strategy 073
0730013502 MA Strategy Basic 2015 MA Strategy 073
0730023101 MA Strategy Consumer 2011 MA Strategy 073
0730023202 MA Strategy Consumer 2012 MA Strategy 073
0730023302 MA Strategy Consumer 2013 MA Strategy 073
0730023402 MA Strategy Consumer 2014 MA Strategy 073
0730023502 MA Strategy Consumer 2015 MA Strategy 073
0730113101 MA Strategy Basic 2011 DSG MA Strategy 073
0730113202 MA Strategy Basic 2012 DSG MA Strategy 073
0730113302 MA Strategy Basic 2013 DSG MA Strategy 073
0730113402 MA Strategy Basic 2014 DSG MA Strategy 073
0730113502 MA Strategy Basic 2015 DSG MA Strategy 073
0730123101 MA Strategy Consumer 2011 DSG MA Strategy 073
0730123202 MA Strategy Consumer 2012 DSG MA Strategy 073
0730123302 MA Strategy Consumer 2013 DSG MA Strategy 073
0730123402 MA Strategy Consumer 2014 DSG MA Strategy 073
0730123502 MA Strategy Consumer 2015 DSG MA Strategy 073
0730213101 MA Strategy Basic 2011 FSG MA Strategy 073
0730213202 MA Strategy Basic 2012 FSG MA Strategy 073
0730213302 MA Strategy Basic 2013 FSG MA Strategy 073
0730213402 MA Strategy Basic 2014 FSG MA Strategy 073
0730213502 MA Strategy Basic 2015 FSG MA Strategy 073
0730223101 MA Strategy Consumer 2011 FSG MA Strategy 073
0730223202 MA Strategy Consumer 2012 FSG MA Strategy 073
0730223302 MA Strategy Consumer 2013 FSG MA Strategy 073
0730223402 MA Strategy Consumer 2014 FSG MA Strategy 073
0730223502 MA Strategy Consumer 2015 FSG MA Strategy 073
0730313101 MA Strategy Basic 2011 ISG MA Strategy 073
0730313202 MA Strategy Basic 2012 ISG MA Strategy 073
0730313302 MA Strategy Basic 2013 ISG MA Strategy 073
0730313402 MA Strategy Basic 2014 ISG MA Strategy 073
0730313502 MA Strategy Basic 2015 ISG MA Strategy 073
0730323101 MA Strategy Consumer 2011 ISG MA Strategy 073
0730323202 MA Strategy Consumer 2012 ISG MA Strategy 073
0730323302 MA Strategy Consumer 2013 ISG MA Strategy 073
0730323402 MA Strategy Consumer 2014 ISG MA Strategy 073
0730323502 MA Strategy Consumer 2015 ISG MA Strategy 073

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE analysis (
	id VARCHAR(10) NOT NULL, 
	name VARCHAR(250), 
	family VARCHAR(3), 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(family) REFERENCES families (id)
);