jacktator

	Object	NamedTuple	DataClass
create	2.94 µs	2.01 µs	2.34 µs
read property	24.7 ns	26.9 ns	24.7 ns
nested property	48.1 ns	75.8 ns	52.1 ns
execute function	829 ns	946 ns	821 ns
size	56 bytes	80 bytes	56 bytes

jacktator

Property	Type	Description
open	float	The opening price.
high	float	The highest price.
low	float	The lowest price.
close	float	The closing price.

jacktator

Property	Type	Description
symbol	str	The ticker symbol.
date	date	A datetime.date object that describes the date.
prices	Prices	A Prices object.
change	float	A float representing the change for the price.

jacktator

jacktator

jacktator

jacktator

select days, count(*) as missions from nasa2_mission where days >=14 and projectname='Shuttle' group by days order by days;

select missionno, launchYear from nasa2_mission natural join nasa2_spacecraft where projectname = 'Shuttle' and launchyear = ( select min(launchyear) from nasa2_mission natural join nasa2_spacecraft where projectname='Shuttle' );

select ass1.astrono, ass1. missionno, ass2.missionno from nasa2_assigned ass1, nasa2_assigned ass2 where ass1.astrono=44 and ass1.projectname='Shuttle' and ass1.missionno!=ass2.missionno and ass2.projectname='Shuttle' and ass1.astrono = ass2.astrono;