Oracle Live SQL - Script: Analytics - How to apply predicates

Statement 1

clear screen

Unsupported Command

Statement 2

drop table planets cascade constraints purge

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 3

create table planets ( name varchar2(20) primary key )

Table created.

Statement 4

insert into planets values ('Mercury')

1 row(s) inserted.

Statement 5

insert into planets values ('Venus')

1 row(s) inserted.

Statement 6

insert into planets values ('Earth')

1 row(s) inserted.

Statement 7

insert into planets values ('Eris')

1 row(s) inserted.

Statement 8

insert into planets values ('Haumea')

1 row(s) inserted.

Statement 9

insert into planets values ('Jupiter')

1 row(s) inserted.

Statement 10

insert into planets values ('Mars')

1 row(s) inserted.

Statement 11

insert into planets values ('Neptune')

1 row(s) inserted.

Statement 12

insert into planets values ('Pluto')

1 row(s) inserted.

Statement 13

insert into planets values ('Saturn')

1 row(s) inserted.

Statement 14

insert into planets values ('Uranus')

1 row(s) inserted.

Statement 15

drop table moons purge

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 16

create table moons ( planet_name varchar2(20) references planets ( name ), name varchar2(20) primary key , radius number(12,2) )

Table created.

Statement 17

insert into moons values ('Earth','Moon',1737.1)

1 row(s) inserted.

Statement 18

insert into moons values ('Eris','Dysnomia',342)

1 row(s) inserted.

Statement 19

insert into moons values ('Haumea','Hi?iaka',195)

1 row(s) inserted.

Statement 20

insert into moons values ('Haumea','Namaka',100)

1 row(s) inserted.

Statement 21

insert into moons values ('Jupiter','Adrastea',8.2 )

1 row(s) inserted.

Statement 22

insert into moons values ('Jupiter','Aitne',1.5)

1 row(s) inserted.

Statement 23

insert into moons values ('Jupiter','Amalthea',83.45 )

1 row(s) inserted.

Statement 24

insert into moons values ('Jupiter','Ananke',14)

1 row(s) inserted.

Statement 25

insert into moons values ('Jupiter','Aoede',2)

1 row(s) inserted.

Statement 26

insert into moons values ('Jupiter','Arche',1.5)

1 row(s) inserted.

Statement 27

insert into moons values ('Jupiter','Autonoe',2)

1 row(s) inserted.

Statement 28

insert into moons values ('Jupiter','Callirrhoe',4.3)

1 row(s) inserted.

Statement 29

insert into moons values ('Jupiter','Callisto',2408.4 )

1 row(s) inserted.

Statement 30

insert into moons values ('Jupiter','Carme',23)

1 row(s) inserted.

Statement 31

insert into moons values ('Jupiter','Carpo',1.5)

1 row(s) inserted.

Statement 32

insert into moons values ('Jupiter','Chaldene',1.9)

1 row(s) inserted.

Statement 33

insert into moons values ('Jupiter','Cyllene',1)

1 row(s) inserted.

Statement 34

insert into moons values ('Jupiter','Dia',2)

1 row(s) inserted.

Statement 35

insert into moons values ('Jupiter','Elara',43)

1 row(s) inserted.

Statement 36

insert into moons values ('Jupiter','Erinome',1.6)

1 row(s) inserted.

Statement 37

insert into moons values ('Jupiter','Euanthe',1.5)

1 row(s) inserted.

Statement 38

insert into moons values ('Jupiter','Eukelade',2)

1 row(s) inserted.

Statement 39

insert into moons values ('Jupiter','Euporie',1)

1 row(s) inserted.

Statement 40

insert into moons values ('Jupiter','Europa',1560.7 )

1 row(s) inserted.

Statement 41

insert into moons values ('Jupiter','Eurydome',1.5)

1 row(s) inserted.

Statement 42

insert into moons values ('Jupiter','Ganymede',2634.1 )

1 row(s) inserted.

Statement 43

insert into moons values ('Jupiter','Harpalyke',2.2)

1 row(s) inserted.

Statement 44

insert into moons values ('Jupiter','Hegemone',1.5)

1 row(s) inserted.

Statement 45

insert into moons values ('Jupiter','Helike',2)

1 row(s) inserted.

Statement 46

insert into moons values ('Jupiter','Hermippe',2)

1 row(s) inserted.

Statement 47

insert into moons values ('Jupiter','Herse',1)

1 row(s) inserted.

Statement 48

insert into moons values ('Jupiter','Himalia',67 )

1 row(s) inserted.

Statement 49

insert into moons values ('Jupiter','Io',1818.1 )

1 row(s) inserted.

Statement 50

insert into moons values ('Jupiter','Iocaste',2.6)

1 row(s) inserted.

Statement 51

insert into moons values ('Jupiter','Isonoe',1.9)

1 row(s) inserted.

Statement 52

insert into moons values ('Jupiter','Kale',1)

1 row(s) inserted.

Statement 53

insert into moons values ('Jupiter','Kallichore',1)

1 row(s) inserted.

Statement 54

insert into moons values ('Jupiter','Kalyke',2.6)

1 row(s) inserted.

Statement 55

insert into moons values ('Jupiter','Kore',1)

1 row(s) inserted.

Statement 56

insert into moons values ('Jupiter','Leda',10)

1 row(s) inserted.

Statement 57

insert into moons values ('Jupiter','Lysithea',18)

1 row(s) inserted.

Statement 58

insert into moons values ('Jupiter','Megaclite',2.7)

1 row(s) inserted.

Statement 59

insert into moons values ('Jupiter','Metis',21.5 )

1 row(s) inserted.

Statement 60

insert into moons values ('Jupiter','Mneme',1)

1 row(s) inserted.

Statement 61

insert into moons values ('Jupiter','Orthosie',1)

1 row(s) inserted.

Statement 62

insert into moons values ('Jupiter','Pasiphae',30)

1 row(s) inserted.

Statement 63

insert into moons values ('Jupiter','Pasithee',1)

1 row(s) inserted.

Statement 64

insert into moons values ('Jupiter','Praxidike',3.4)

1 row(s) inserted.

Statement 65

insert into moons values ('Jupiter','S/2003 J 10',1)

1 row(s) inserted.

Statement 66

insert into moons values ('Jupiter','S/2003 J 12',0.5)

1 row(s) inserted.

Statement 67

insert into moons values ('Jupiter','S/2003 J 15',1)

1 row(s) inserted.

Statement 68

insert into moons values ('Jupiter','S/2003 J 16',1)

1 row(s) inserted.

Statement 69

insert into moons values ('Jupiter','S/2003 J 18',1)

1 row(s) inserted.

Statement 70

insert into moons values ('Jupiter','S/2003 J 19',1)

1 row(s) inserted.

Statement 71

insert into moons values ('Jupiter','S/2003 J 2',1)

1 row(s) inserted.

Statement 72

insert into moons values ('Jupiter','S/2003 J 23',1)

1 row(s) inserted.

Statement 73

insert into moons values ('Jupiter','S/2003 J 3',1)

1 row(s) inserted.

Statement 74

insert into moons values ('Jupiter','S/2003 J 4',1)

1 row(s) inserted.

Statement 75

insert into moons values ('Jupiter','S/2003 J 5',2)

1 row(s) inserted.

Statement 76

insert into moons values ('Jupiter','S/2003 J 9',0.5)

1 row(s) inserted.

Statement 77

insert into moons values ('Jupiter','S/2010 J 1',1)

1 row(s) inserted.

Statement 78

insert into moons values ('Jupiter','S/2010 J 2',0.5)

1 row(s) inserted.

Statement 79

insert into moons values ('Jupiter','S/2011 J 1',0.5)

1 row(s) inserted.

Statement 80

insert into moons values ('Jupiter','S/2011 J 2',0.5)

1 row(s) inserted.

Statement 81

insert into moons values ('Jupiter','Sinope',19)

1 row(s) inserted.

Statement 82

insert into moons values ('Jupiter','Sponde',1)

1 row(s) inserted.

Statement 83

insert into moons values ('Jupiter','Taygete',2.5)

1 row(s) inserted.

Statement 84

insert into moons values ('Jupiter','Thebe',49.3 )

1 row(s) inserted.

Statement 85

insert into moons values ('Jupiter','Thelxinoe',1)

1 row(s) inserted.

Statement 86

insert into moons values ('Jupiter','Themisto',4)

1 row(s) inserted.

Statement 87

insert into moons values ('Jupiter','Thyone',2)

1 row(s) inserted.

Statement 88

insert into moons values ('Mars','Deimos',6.2 )

1 row(s) inserted.

Statement 89

insert into moons values ('Mars','Phobos',11.1 )

1 row(s) inserted.

Statement 90

insert into moons values ('Neptune','Despina',75 )

1 row(s) inserted.

Statement 91

insert into moons values ('Neptune','Galatea',88 )

1 row(s) inserted.

Statement 92

insert into moons values ('Neptune','Halimede',31)

1 row(s) inserted.

Statement 93

insert into moons values ('Neptune','Laomedeia',21)

1 row(s) inserted.

Statement 94

insert into moons values ('Neptune','Larissa',97 )

1 row(s) inserted.

Statement 95

insert into moons values ('Neptune','Naiad',33 )

1 row(s) inserted.

Statement 96

insert into moons values ('Neptune','Nereid',170 )

1 row(s) inserted.

Statement 97

insert into moons values ('Neptune','Neso',30)

1 row(s) inserted.

Statement 98

insert into moons values ('Neptune','Proteus',210 )

1 row(s) inserted.

Statement 99

insert into moons values ('Neptune','Psamathe',20)

1 row(s) inserted.

Statement 100

insert into moons values ('Neptune','S/2004 N 1',8)

1 row(s) inserted.

Statement 101

insert into moons values ('Neptune','Sao',22)

1 row(s) inserted.

Statement 102

insert into moons values ('Neptune','Thalassa',41 )

1 row(s) inserted.

Statement 103

insert into moons values ('Neptune','Triton',1353.4 )

1 row(s) inserted.

Statement 104

insert into moons values ('Pluto','Charon',603.6 )

1 row(s) inserted.

Statement 105

insert into moons values ('Pluto','Hydra',30.5)

1 row(s) inserted.

Statement 106

insert into moons values ('Pluto','Kerberos',6.5)

1 row(s) inserted.

Statement 107

insert into moons values ('Pluto','Nix',23)

1 row(s) inserted.

Statement 108

insert into moons values ('Pluto','Styx',5)

1 row(s) inserted.

Statement 109

insert into moons values ('Saturn','Aegaeon',0.25)

1 row(s) inserted.

Statement 110

insert into moons values ('Saturn','Aegir',3)

1 row(s) inserted.

Statement 111

insert into moons values ('Saturn','Albiorix',16)

1 row(s) inserted.

Statement 112

insert into moons values ('Saturn','Anthe',1)

1 row(s) inserted.

Statement 113

insert into moons values ('Saturn','Atlas',15.3 )

1 row(s) inserted.

Statement 114

insert into moons values ('Saturn','Bebhionn',3)

1 row(s) inserted.

Statement 115

insert into moons values ('Saturn','Bergelmir',3)

1 row(s) inserted.

Statement 116

insert into moons values ('Saturn','Bestla',3.5)

1 row(s) inserted.

Statement 117

insert into moons values ('Saturn','Calypso',9.5 )

1 row(s) inserted.

Statement 118

insert into moons values ('Saturn','Daphnis',3)

1 row(s) inserted.

Statement 119

insert into moons values ('Saturn','Dione',562.5 )

1 row(s) inserted.

Statement 120

insert into moons values ('Saturn','Enceladus',252.3 )

1 row(s) inserted.

Statement 121

insert into moons values ('Saturn','Epimetheus',58.3 )

1 row(s) inserted.

Statement 122

insert into moons values ('Saturn','Erriapus',5)

1 row(s) inserted.

Statement 123

insert into moons values ('Saturn','Farbauti',2.5)

1 row(s) inserted.

Statement 124

insert into moons values ('Saturn','Fenrir',2)

1 row(s) inserted.

Statement 125

insert into moons values ('Saturn','Fornjot',3)

1 row(s) inserted.

Statement 126

insert into moons values ('Saturn','Greip',3)

1 row(s) inserted.

Statement 127

insert into moons values ('Saturn','Hati',3)

1 row(s) inserted.

Statement 128

insert into moons values ('Saturn','Helene',16 )

1 row(s) inserted.

Statement 129

insert into moons values ('Saturn','Hyperion',133.0 )

1 row(s) inserted.

Statement 130

insert into moons values ('Saturn','Hyrrokkin',4)

1 row(s) inserted.

Statement 131

insert into moons values ('Saturn','Iapetus',734.5 )

1 row(s) inserted.

Statement 132

insert into moons values ('Saturn','Ijiraq',6)

1 row(s) inserted.

Statement 133

insert into moons values ('Saturn','Janus',90.4 )

1 row(s) inserted.

Statement 134

insert into moons values ('Saturn','Jarnsaxa',3)

1 row(s) inserted.

Statement 135

insert into moons values ('Saturn','Kari',3.5)

1 row(s) inserted.

Statement 136

insert into moons values ('Saturn','Kiviuq',8)

1 row(s) inserted.

Statement 137

insert into moons values ('Saturn','Loge',3)

1 row(s) inserted.

Statement 138

insert into moons values ('Saturn','Methone',1.6)

1 row(s) inserted.

Statement 139

insert into moons values ('Saturn','Mimas',198.2 )

1 row(s) inserted.

Statement 140

insert into moons values ('Saturn','Mundilfari',3.5)

1 row(s) inserted.

Statement 141

insert into moons values ('Saturn','Narvi',3.5)

1 row(s) inserted.

Statement 142

insert into moons values ('Saturn','Paaliaq',11)

1 row(s) inserted.

Statement 143

insert into moons values ('Saturn','Pallene',2)

1 row(s) inserted.

Statement 144

insert into moons values ('Saturn','Pan',12.8)

1 row(s) inserted.

Statement 145

insert into moons values ('Saturn','Pandora',40.6 )

1 row(s) inserted.

Statement 146

insert into moons values ('Saturn','Phoebe',106.6 )

1 row(s) inserted.

Statement 147

insert into moons values ('Saturn','Polydeuces',1.25)

1 row(s) inserted.

Statement 148

insert into moons values ('Saturn','Prometheus',46.8 )

1 row(s) inserted.

Statement 149

insert into moons values ('Saturn','Rhea',764.5 )

1 row(s) inserted.

Statement 150

insert into moons values ('Saturn','S/2004 S 12',2.5)

1 row(s) inserted.

Statement 151

insert into moons values ('Saturn','S/2004 S 13',3)

1 row(s) inserted.

Statement 152

insert into moons values ('Saturn','S/2004 S 17',2)

1 row(s) inserted.

Statement 153

insert into moons values ('Saturn','S/2004 S 7',3)

1 row(s) inserted.

Statement 154

insert into moons values ('Saturn','S/2006 S 1',3)

1 row(s) inserted.

Statement 155

insert into moons values ('Saturn','S/2006 S 3',3)

1 row(s) inserted.

Statement 156

insert into moons values ('Saturn','S/2007 S 2',3)

1 row(s) inserted.

Statement 157

insert into moons values ('Saturn','S/2007 S 3',3)

1 row(s) inserted.

Statement 158

insert into moons values ('Saturn','S/2009 S 1',0.15)

1 row(s) inserted.

Statement 159

insert into moons values ('Saturn','Siarnaq',20)

1 row(s) inserted.

Statement 160

insert into moons values ('Saturn','Skathi',4)

1 row(s) inserted.

Statement 161

insert into moons values ('Saturn','Skoll',3)

1 row(s) inserted.

Statement 162

insert into moons values ('Saturn','Surtur',3)

1 row(s) inserted.

Statement 163

insert into moons values ('Saturn','Suttungr',3.5)

1 row(s) inserted.

Statement 164

insert into moons values ('Saturn','Tarqeq',3.5)

1 row(s) inserted.

Statement 165

insert into moons values ('Saturn','Tarvos',7.5)

1 row(s) inserted.

Statement 166

insert into moons values ('Saturn','Telesto',12 )

1 row(s) inserted.

Statement 167

insert into moons values ('Saturn','Tethys',536.3 )

1 row(s) inserted.

Statement 168

insert into moons values ('Saturn','Thrymr',3.5)

1 row(s) inserted.

Statement 169

insert into moons values ('Saturn','Titan',2575.5 )

1 row(s) inserted.

Statement 170

insert into moons values ('Saturn','Ymir',9)

1 row(s) inserted.

Statement 171

insert into moons values ('Uranus','Ariel',578.9 )

1 row(s) inserted.

Statement 172

insert into moons values ('Uranus','Belinda',40.3 )

1 row(s) inserted.

Statement 173

insert into moons values ('Uranus','Bianca',25.7 )

1 row(s) inserted.

Statement 174

insert into moons values ('Uranus','Caliban',49)

1 row(s) inserted.

Statement 175

insert into moons values ('Uranus','Cordelia',20.1 )

1 row(s) inserted.

Statement 176

insert into moons values ('Uranus','Cressida',39.8 )

1 row(s) inserted.

Statement 177

insert into moons values ('Uranus','Cupid',5)

1 row(s) inserted.

Statement 178

insert into moons values ('Uranus','Desdemona',32.0 )

1 row(s) inserted.

Statement 179

insert into moons values ('Uranus','Ferdinand',6)

1 row(s) inserted.

Statement 180

insert into moons values ('Uranus','Francisco',6)

1 row(s) inserted.

Statement 181

insert into moons values ('Uranus','Juliet',46.8 )

1 row(s) inserted.

Statement 182

insert into moons values ('Uranus','Mab',5)

1 row(s) inserted.

Statement 183

insert into moons values ('Uranus','Margaret',5.5)

1 row(s) inserted.

Statement 184

insert into moons values ('Uranus','Miranda',235.8 )

1 row(s) inserted.

Statement 185

insert into moons values ('Uranus','Oberon',761.4 )

1 row(s) inserted.

Statement 186

insert into moons values ('Uranus','Ophelia',21.4 )

1 row(s) inserted.

Statement 187

insert into moons values ('Uranus','Perdita',10)

1 row(s) inserted.

Statement 188

insert into moons values ('Uranus','Portia',67.6 )

1 row(s) inserted.

Statement 189

insert into moons values ('Uranus','Prospero',15)

1 row(s) inserted.

Statement 190

insert into moons values ('Uranus','Puck',81 )

1 row(s) inserted.

Statement 191

insert into moons values ('Uranus','Rosalind',36 )

1 row(s) inserted.

Statement 192

insert into moons values ('Uranus','Setebos',15)

1 row(s) inserted.

Statement 193

insert into moons values ('Uranus','Stephano',10)

1 row(s) inserted.

Statement 194

insert into moons values ('Uranus','Sycorax',75)

1 row(s) inserted.

Statement 195

insert into moons values ('Uranus','Titania',788.9 )

1 row(s) inserted.

Statement 196

insert into moons values ('Uranus','Trinculo',5)

1 row(s) inserted.

Statement 197

insert into moons values ('Uranus','Umbriel',584.7 )

1 row(s) inserted.

Statement 198

commit

Statement processed.

Statement 199

select planet_name, name, radius,  
       row_number() over ( order by radius desc) as size_rank
from   moons
where  planet_name in ('Earth','Mars','Saturn')
and    row_number() over ( order by radius desc) <= 3

select *
from (
  select planet_name, name, radius,  
         row_number() over ( order by radius desc) as size_rank
  from   moons
  where  planet_name in ('Earth','Mars','Saturn')
)
where size_rank <= 3

ORA-30483: window  functions are not allowed here

More Details: https://docs.oracle.com/error-help/db/ora-30483

Statement 200

clear screen

Unsupported Command

Statement 201

drop table planets cascade constraints purge

Table dropped.

Statement 202

create table planets ( name varchar2(20) primary key )

Table created.

Statement 203

insert into planets values ('Mercury')

1 row(s) inserted.

Statement 204

insert into planets values ('Venus')

1 row(s) inserted.

Statement 205

insert into planets values ('Earth')

1 row(s) inserted.

Statement 206

insert into planets values ('Eris')

1 row(s) inserted.

Statement 207

insert into planets values ('Haumea')

1 row(s) inserted.

Statement 208

insert into planets values ('Jupiter')

1 row(s) inserted.

Statement 209

insert into planets values ('Mars')

1 row(s) inserted.

Statement 210

insert into planets values ('Neptune')

1 row(s) inserted.

Statement 211

insert into planets values ('Pluto')

1 row(s) inserted.

Statement 212

insert into planets values ('Saturn')

1 row(s) inserted.

Statement 213

insert into planets values ('Uranus')

1 row(s) inserted.

Statement 214

drop table moons purge

Table dropped.

Statement 215

create table moons ( planet_name varchar2(20) references planets ( name ), name varchar2(20) primary key , radius number(12,2) )

Table created.

Statement 216

insert into moons values ('Earth','Moon',1737.1)

1 row(s) inserted.

Statement 217

insert into moons values ('Eris','Dysnomia',342)

1 row(s) inserted.

Statement 218

insert into moons values ('Haumea','Hi?iaka',195)

1 row(s) inserted.

Statement 219

insert into moons values ('Haumea','Namaka',100)

1 row(s) inserted.

Statement 220

insert into moons values ('Jupiter','Adrastea',8.2 )

1 row(s) inserted.

Statement 221

insert into moons values ('Jupiter','Aitne',1.5)

1 row(s) inserted.

Statement 222

insert into moons values ('Jupiter','Amalthea',83.45 )

1 row(s) inserted.

Statement 223

insert into moons values ('Jupiter','Ananke',14)

1 row(s) inserted.

Statement 224

insert into moons values ('Jupiter','Aoede',2)

1 row(s) inserted.

Statement 225

insert into moons values ('Jupiter','Arche',1.5)

1 row(s) inserted.

Statement 226

insert into moons values ('Jupiter','Autonoe',2)

1 row(s) inserted.

Statement 227

insert into moons values ('Jupiter','Callirrhoe',4.3)

1 row(s) inserted.

Statement 228

insert into moons values ('Jupiter','Callisto',2408.4 )

1 row(s) inserted.

Statement 229

insert into moons values ('Jupiter','Carme',23)

1 row(s) inserted.

Statement 230

insert into moons values ('Jupiter','Carpo',1.5)

1 row(s) inserted.

Statement 231

insert into moons values ('Jupiter','Chaldene',1.9)

1 row(s) inserted.

Statement 232

insert into moons values ('Jupiter','Cyllene',1)

1 row(s) inserted.

Statement 233

insert into moons values ('Jupiter','Dia',2)

1 row(s) inserted.

Statement 234

insert into moons values ('Jupiter','Elara',43)

1 row(s) inserted.

Statement 235

insert into moons values ('Jupiter','Erinome',1.6)

1 row(s) inserted.

Statement 236

insert into moons values ('Jupiter','Euanthe',1.5)

1 row(s) inserted.

Statement 237

insert into moons values ('Jupiter','Eukelade',2)

1 row(s) inserted.

Statement 238

insert into moons values ('Jupiter','Euporie',1)

1 row(s) inserted.

Statement 239

insert into moons values ('Jupiter','Europa',1560.7 )

1 row(s) inserted.

Statement 240

insert into moons values ('Jupiter','Eurydome',1.5)

1 row(s) inserted.

Statement 241

insert into moons values ('Jupiter','Ganymede',2634.1 )

1 row(s) inserted.

Statement 242

insert into moons values ('Jupiter','Harpalyke',2.2)

1 row(s) inserted.

Statement 243

insert into moons values ('Jupiter','Hegemone',1.5)

1 row(s) inserted.

Statement 244

insert into moons values ('Jupiter','Helike',2)

1 row(s) inserted.

Statement 245

insert into moons values ('Jupiter','Hermippe',2)

1 row(s) inserted.

Statement 246

insert into moons values ('Jupiter','Herse',1)

1 row(s) inserted.

Statement 247

insert into moons values ('Jupiter','Himalia',67 )

1 row(s) inserted.

Statement 248

insert into moons values ('Jupiter','Io',1818.1 )

1 row(s) inserted.

Statement 249

insert into moons values ('Jupiter','Iocaste',2.6)

1 row(s) inserted.

Statement 250

insert into moons values ('Jupiter','Isonoe',1.9)

1 row(s) inserted.

Statement 251

insert into moons values ('Jupiter','Kale',1)

1 row(s) inserted.

Statement 252

insert into moons values ('Jupiter','Kallichore',1)

1 row(s) inserted.

Statement 253

insert into moons values ('Jupiter','Kalyke',2.6)

1 row(s) inserted.

Statement 254

insert into moons values ('Jupiter','Kore',1)

1 row(s) inserted.

Statement 255

insert into moons values ('Jupiter','Leda',10)

1 row(s) inserted.

Statement 256

insert into moons values ('Jupiter','Lysithea',18)

1 row(s) inserted.

Statement 257

insert into moons values ('Jupiter','Megaclite',2.7)

1 row(s) inserted.

Statement 258

insert into moons values ('Jupiter','Metis',21.5 )

1 row(s) inserted.

Statement 259

insert into moons values ('Jupiter','Mneme',1)

1 row(s) inserted.

Statement 260

insert into moons values ('Jupiter','Orthosie',1)

1 row(s) inserted.

Statement 261

insert into moons values ('Jupiter','Pasiphae',30)

1 row(s) inserted.

Statement 262

insert into moons values ('Jupiter','Pasithee',1)

1 row(s) inserted.

Statement 263

insert into moons values ('Jupiter','Praxidike',3.4)

1 row(s) inserted.

Statement 264

insert into moons values ('Jupiter','S/2003 J 10',1)

1 row(s) inserted.

Statement 265

insert into moons values ('Jupiter','S/2003 J 12',0.5)

1 row(s) inserted.

Statement 266

insert into moons values ('Jupiter','S/2003 J 15',1)

1 row(s) inserted.

Statement 267

insert into moons values ('Jupiter','S/2003 J 16',1)

1 row(s) inserted.

Statement 268

insert into moons values ('Jupiter','S/2003 J 18',1)

1 row(s) inserted.

Statement 269

insert into moons values ('Jupiter','S/2003 J 19',1)

1 row(s) inserted.

Statement 270

insert into moons values ('Jupiter','S/2003 J 2',1)

1 row(s) inserted.

Statement 271

insert into moons values ('Jupiter','S/2003 J 23',1)

1 row(s) inserted.

Statement 272

insert into moons values ('Jupiter','S/2003 J 3',1)

1 row(s) inserted.

Statement 273

insert into moons values ('Jupiter','S/2003 J 4',1)

1 row(s) inserted.

Statement 274

insert into moons values ('Jupiter','S/2003 J 5',2)

1 row(s) inserted.

Statement 275

insert into moons values ('Jupiter','S/2003 J 9',0.5)

1 row(s) inserted.

Statement 276

insert into moons values ('Jupiter','S/2010 J 1',1)

1 row(s) inserted.

Statement 277

insert into moons values ('Jupiter','S/2010 J 2',0.5)

1 row(s) inserted.

Statement 278

insert into moons values ('Jupiter','S/2011 J 1',0.5)

1 row(s) inserted.

Statement 279

insert into moons values ('Jupiter','S/2011 J 2',0.5)

1 row(s) inserted.

Statement 280

insert into moons values ('Jupiter','Sinope',19)

1 row(s) inserted.

Statement 281

insert into moons values ('Jupiter','Sponde',1)

1 row(s) inserted.

Statement 282

insert into moons values ('Jupiter','Taygete',2.5)

1 row(s) inserted.

Statement 283

insert into moons values ('Jupiter','Thebe',49.3 )

1 row(s) inserted.

Statement 284

insert into moons values ('Jupiter','Thelxinoe',1)

1 row(s) inserted.

Statement 285

insert into moons values ('Jupiter','Themisto',4)

1 row(s) inserted.

Statement 286

insert into moons values ('Jupiter','Thyone',2)

1 row(s) inserted.

Statement 287

insert into moons values ('Mars','Deimos',6.2 )

1 row(s) inserted.

Statement 288

insert into moons values ('Mars','Phobos',11.1 )

1 row(s) inserted.

Statement 289

insert into moons values ('Neptune','Despina',75 )

1 row(s) inserted.

Statement 290

insert into moons values ('Neptune','Galatea',88 )

1 row(s) inserted.

Statement 291

insert into moons values ('Neptune','Halimede',31)

1 row(s) inserted.

Statement 292

insert into moons values ('Neptune','Laomedeia',21)

1 row(s) inserted.

Statement 293

insert into moons values ('Neptune','Larissa',97 )

1 row(s) inserted.

Statement 294

insert into moons values ('Neptune','Naiad',33 )

1 row(s) inserted.

Statement 295

insert into moons values ('Neptune','Nereid',170 )

1 row(s) inserted.

Statement 296

insert into moons values ('Neptune','Neso',30)

1 row(s) inserted.

Statement 297

insert into moons values ('Neptune','Proteus',210 )

1 row(s) inserted.

Statement 298

insert into moons values ('Neptune','Psamathe',20)

1 row(s) inserted.

Statement 299

insert into moons values ('Neptune','S/2004 N 1',8)

1 row(s) inserted.

Statement 300

insert into moons values ('Neptune','Sao',22)

1 row(s) inserted.

Statement 301

insert into moons values ('Neptune','Thalassa',41 )

1 row(s) inserted.

Statement 302

insert into moons values ('Neptune','Triton',1353.4 )

1 row(s) inserted.

Statement 303

insert into moons values ('Pluto','Charon',603.6 )

1 row(s) inserted.

Statement 304

insert into moons values ('Pluto','Hydra',30.5)

1 row(s) inserted.

Statement 305

insert into moons values ('Pluto','Kerberos',6.5)

1 row(s) inserted.

Statement 306

insert into moons values ('Pluto','Nix',23)

1 row(s) inserted.

Statement 307

insert into moons values ('Pluto','Styx',5)

1 row(s) inserted.

Statement 308

insert into moons values ('Saturn','Aegaeon',0.25)

1 row(s) inserted.

Statement 309

insert into moons values ('Saturn','Aegir',3)

1 row(s) inserted.

Statement 310

insert into moons values ('Saturn','Albiorix',16)

1 row(s) inserted.

Statement 311

insert into moons values ('Saturn','Anthe',1)

1 row(s) inserted.

Statement 312

insert into moons values ('Saturn','Atlas',15.3 )

1 row(s) inserted.

Statement 313

insert into moons values ('Saturn','Bebhionn',3)

1 row(s) inserted.

Statement 314

insert into moons values ('Saturn','Bergelmir',3)

1 row(s) inserted.

Statement 315

insert into moons values ('Saturn','Bestla',3.5)

1 row(s) inserted.

Statement 316

insert into moons values ('Saturn','Calypso',9.5 )

1 row(s) inserted.

Statement 317

insert into moons values ('Saturn','Daphnis',3)

1 row(s) inserted.

Statement 318

insert into moons values ('Saturn','Dione',562.5 )

1 row(s) inserted.

Statement 319

insert into moons values ('Saturn','Enceladus',252.3 )

1 row(s) inserted.

Statement 320

insert into moons values ('Saturn','Epimetheus',58.3 )

1 row(s) inserted.

Statement 321

insert into moons values ('Saturn','Erriapus',5)

1 row(s) inserted.

Statement 322

insert into moons values ('Saturn','Farbauti',2.5)

1 row(s) inserted.

Statement 323

insert into moons values ('Saturn','Fenrir',2)

1 row(s) inserted.

Statement 324

insert into moons values ('Saturn','Fornjot',3)

1 row(s) inserted.

Statement 325

insert into moons values ('Saturn','Greip',3)

1 row(s) inserted.

Statement 326

insert into moons values ('Saturn','Hati',3)

1 row(s) inserted.

Statement 327

insert into moons values ('Saturn','Helene',16 )

1 row(s) inserted.

Statement 328

insert into moons values ('Saturn','Hyperion',133.0 )

1 row(s) inserted.

Statement 329

insert into moons values ('Saturn','Hyrrokkin',4)

1 row(s) inserted.

Statement 330

insert into moons values ('Saturn','Iapetus',734.5 )

1 row(s) inserted.

Statement 331

insert into moons values ('Saturn','Ijiraq',6)

1 row(s) inserted.

Statement 332

insert into moons values ('Saturn','Janus',90.4 )

1 row(s) inserted.

Statement 333

insert into moons values ('Saturn','Jarnsaxa',3)

1 row(s) inserted.

Statement 334

insert into moons values ('Saturn','Kari',3.5)

1 row(s) inserted.

Statement 335

insert into moons values ('Saturn','Kiviuq',8)

1 row(s) inserted.

Statement 336

insert into moons values ('Saturn','Loge',3)

1 row(s) inserted.

Statement 337

insert into moons values ('Saturn','Methone',1.6)

1 row(s) inserted.

Statement 338

insert into moons values ('Saturn','Mimas',198.2 )

1 row(s) inserted.

Statement 339

insert into moons values ('Saturn','Mundilfari',3.5)

1 row(s) inserted.

Statement 340

insert into moons values ('Saturn','Narvi',3.5)

1 row(s) inserted.

Statement 341

insert into moons values ('Saturn','Paaliaq',11)

1 row(s) inserted.

Statement 342

insert into moons values ('Saturn','Pallene',2)

1 row(s) inserted.

Statement 343

insert into moons values ('Saturn','Pan',12.8)

1 row(s) inserted.

Statement 344

insert into moons values ('Saturn','Pandora',40.6 )

1 row(s) inserted.

Statement 345

insert into moons values ('Saturn','Phoebe',106.6 )

1 row(s) inserted.

Statement 346

insert into moons values ('Saturn','Polydeuces',1.25)

1 row(s) inserted.

Statement 347

insert into moons values ('Saturn','Prometheus',46.8 )

1 row(s) inserted.

Statement 348

insert into moons values ('Saturn','Rhea',764.5 )

1 row(s) inserted.

Statement 349

insert into moons values ('Saturn','S/2004 S 12',2.5)

1 row(s) inserted.

Statement 350

insert into moons values ('Saturn','S/2004 S 13',3)

1 row(s) inserted.

Statement 351

insert into moons values ('Saturn','S/2004 S 17',2)

1 row(s) inserted.

Statement 352

insert into moons values ('Saturn','S/2004 S 7',3)

1 row(s) inserted.

Statement 353

insert into moons values ('Saturn','S/2006 S 1',3)

1 row(s) inserted.

Statement 354

insert into moons values ('Saturn','S/2006 S 3',3)

1 row(s) inserted.

Statement 355

insert into moons values ('Saturn','S/2007 S 2',3)

1 row(s) inserted.

Statement 356

insert into moons values ('Saturn','S/2007 S 3',3)

1 row(s) inserted.

Statement 357

insert into moons values ('Saturn','S/2009 S 1',0.15)

1 row(s) inserted.

Statement 358

insert into moons values ('Saturn','Siarnaq',20)

1 row(s) inserted.

Statement 359

insert into moons values ('Saturn','Skathi',4)

1 row(s) inserted.

Statement 360

insert into moons values ('Saturn','Skoll',3)

1 row(s) inserted.

Statement 361

insert into moons values ('Saturn','Surtur',3)

1 row(s) inserted.

Statement 362

insert into moons values ('Saturn','Suttungr',3.5)

1 row(s) inserted.

Statement 363

insert into moons values ('Saturn','Tarqeq',3.5)

1 row(s) inserted.

Statement 364

insert into moons values ('Saturn','Tarvos',7.5)

1 row(s) inserted.

Statement 365

insert into moons values ('Saturn','Telesto',12 )

1 row(s) inserted.

Statement 366

insert into moons values ('Saturn','Tethys',536.3 )

1 row(s) inserted.

Statement 367

insert into moons values ('Saturn','Thrymr',3.5)

1 row(s) inserted.

Statement 368

insert into moons values ('Saturn','Titan',2575.5 )

1 row(s) inserted.

Statement 369

insert into moons values ('Saturn','Ymir',9)

1 row(s) inserted.

Statement 370

insert into moons values ('Uranus','Ariel',578.9 )

1 row(s) inserted.

Statement 371

insert into moons values ('Uranus','Belinda',40.3 )

1 row(s) inserted.

Statement 372

insert into moons values ('Uranus','Bianca',25.7 )

1 row(s) inserted.

Statement 373

insert into moons values ('Uranus','Caliban',49)

1 row(s) inserted.

Statement 374

insert into moons values ('Uranus','Cordelia',20.1 )

1 row(s) inserted.

Statement 375

insert into moons values ('Uranus','Cressida',39.8 )

1 row(s) inserted.

Statement 376

insert into moons values ('Uranus','Cupid',5)

1 row(s) inserted.

Statement 377

insert into moons values ('Uranus','Desdemona',32.0 )

1 row(s) inserted.

Statement 378

insert into moons values ('Uranus','Ferdinand',6)

1 row(s) inserted.

Statement 379

insert into moons values ('Uranus','Francisco',6)

1 row(s) inserted.

Statement 380

insert into moons values ('Uranus','Juliet',46.8 )

1 row(s) inserted.

Statement 381

insert into moons values ('Uranus','Mab',5)

1 row(s) inserted.

Statement 382

insert into moons values ('Uranus','Margaret',5.5)

1 row(s) inserted.

Statement 383

insert into moons values ('Uranus','Miranda',235.8 )

1 row(s) inserted.

Statement 384

insert into moons values ('Uranus','Oberon',761.4 )

1 row(s) inserted.

Statement 385

insert into moons values ('Uranus','Ophelia',21.4 )

1 row(s) inserted.

Statement 386

insert into moons values ('Uranus','Perdita',10)

1 row(s) inserted.

Statement 387

insert into moons values ('Uranus','Portia',67.6 )

1 row(s) inserted.

Statement 388

insert into moons values ('Uranus','Prospero',15)

1 row(s) inserted.

Statement 389

insert into moons values ('Uranus','Puck',81 )

1 row(s) inserted.

Statement 390

insert into moons values ('Uranus','Rosalind',36 )

1 row(s) inserted.

Statement 391

insert into moons values ('Uranus','Setebos',15)

1 row(s) inserted.

Statement 392

insert into moons values ('Uranus','Stephano',10)

1 row(s) inserted.

Statement 393

insert into moons values ('Uranus','Sycorax',75)

1 row(s) inserted.

Statement 394

insert into moons values ('Uranus','Titania',788.9 )

1 row(s) inserted.

Statement 395

insert into moons values ('Uranus','Trinculo',5)

1 row(s) inserted.

Statement 396

insert into moons values ('Uranus','Umbriel',584.7 )

1 row(s) inserted.

Statement 397

commit

Statement processed.

Statement 398

select planet_name, name, radius,  
       row_number() over ( order by radius desc) as size_rank
from   moons
where  planet_name in ('Earth','Mars','Saturn')
and    row_number() over ( order by radius desc) <= 3

select *
from (
  select planet_name, name, radius,  
         row_number() over ( order by radius desc) as size_rank
  from   moons
  where  planet_name in ('Earth','Mars','Saturn')
)
where size_rank <= 3

ORA-30483: window  functions are not allowed here

More Details: https://docs.oracle.com/error-help/db/ora-30483

Statement 399

clear screen

Unsupported Command

Statement 400

drop table planets cascade constraints purge

Table dropped.

Statement 401

create table planets ( name varchar2(20) primary key )

Table created.

Statement 402

insert into planets values ('Mercury')

1 row(s) inserted.

Statement 403

insert into planets values ('Venus')

1 row(s) inserted.

Statement 404

insert into planets values ('Earth')

1 row(s) inserted.

Statement 405

insert into planets values ('Eris')

1 row(s) inserted.

Statement 406

insert into planets values ('Haumea')

1 row(s) inserted.

Statement 407

insert into planets values ('Jupiter')

1 row(s) inserted.

Statement 408

insert into planets values ('Mars')

1 row(s) inserted.

Statement 409

insert into planets values ('Neptune')

1 row(s) inserted.

Statement 410

insert into planets values ('Pluto')

1 row(s) inserted.

Statement 411

insert into planets values ('Saturn')

1 row(s) inserted.

Statement 412

insert into planets values ('Uranus')

1 row(s) inserted.

Statement 413

drop table moons purge

Table dropped.

Statement 414

create table moons ( planet_name varchar2(20) references planets ( name ), name varchar2(20) primary key , radius number(12,2) )

Table created.

Statement 415

insert into moons values ('Earth','Moon',1737.1)

1 row(s) inserted.

Statement 416

insert into moons values ('Eris','Dysnomia',342)

1 row(s) inserted.

Statement 417

insert into moons values ('Haumea','Hi?iaka',195)

1 row(s) inserted.

Statement 418

insert into moons values ('Haumea','Namaka',100)

1 row(s) inserted.

Statement 419

insert into moons values ('Jupiter','Adrastea',8.2 )

1 row(s) inserted.

Statement 420

insert into moons values ('Jupiter','Aitne',1.5)

1 row(s) inserted.

Statement 421

insert into moons values ('Jupiter','Amalthea',83.45 )

1 row(s) inserted.

Statement 422

insert into moons values ('Jupiter','Ananke',14)

1 row(s) inserted.

Statement 423

insert into moons values ('Jupiter','Aoede',2)

1 row(s) inserted.

Statement 424

insert into moons values ('Jupiter','Arche',1.5)

1 row(s) inserted.

Statement 425

insert into moons values ('Jupiter','Autonoe',2)

1 row(s) inserted.

Statement 426

insert into moons values ('Jupiter','Callirrhoe',4.3)

1 row(s) inserted.

Statement 427

insert into moons values ('Jupiter','Callisto',2408.4 )

1 row(s) inserted.

Statement 428

insert into moons values ('Jupiter','Carme',23)

1 row(s) inserted.

Statement 429

insert into moons values ('Jupiter','Carpo',1.5)

1 row(s) inserted.

Statement 430

insert into moons values ('Jupiter','Chaldene',1.9)

1 row(s) inserted.

Statement 431

insert into moons values ('Jupiter','Cyllene',1)

1 row(s) inserted.

Statement 432

insert into moons values ('Jupiter','Dia',2)

1 row(s) inserted.

Statement 433

insert into moons values ('Jupiter','Elara',43)

1 row(s) inserted.

Statement 434

insert into moons values ('Jupiter','Erinome',1.6)

1 row(s) inserted.

Statement 435

insert into moons values ('Jupiter','Euanthe',1.5)

1 row(s) inserted.

Statement 436

insert into moons values ('Jupiter','Eukelade',2)

1 row(s) inserted.

Statement 437

insert into moons values ('Jupiter','Euporie',1)

1 row(s) inserted.

Statement 438

insert into moons values ('Jupiter','Europa',1560.7 )

1 row(s) inserted.

Statement 439

insert into moons values ('Jupiter','Eurydome',1.5)

1 row(s) inserted.

Statement 440

insert into moons values ('Jupiter','Ganymede',2634.1 )

1 row(s) inserted.

Statement 441

insert into moons values ('Jupiter','Harpalyke',2.2)

1 row(s) inserted.

Statement 442

insert into moons values ('Jupiter','Hegemone',1.5)

1 row(s) inserted.

Statement 443

insert into moons values ('Jupiter','Helike',2)

1 row(s) inserted.

Statement 444

insert into moons values ('Jupiter','Hermippe',2)

1 row(s) inserted.

Statement 445

insert into moons values ('Jupiter','Herse',1)

1 row(s) inserted.

Statement 446

insert into moons values ('Jupiter','Himalia',67 )

1 row(s) inserted.

Statement 447

insert into moons values ('Jupiter','Io',1818.1 )

1 row(s) inserted.

Statement 448

insert into moons values ('Jupiter','Iocaste',2.6)

1 row(s) inserted.

Statement 449

insert into moons values ('Jupiter','Isonoe',1.9)

1 row(s) inserted.

Statement 450

insert into moons values ('Jupiter','Kale',1)

1 row(s) inserted.

Statement 451

insert into moons values ('Jupiter','Kallichore',1)

1 row(s) inserted.

Statement 452

insert into moons values ('Jupiter','Kalyke',2.6)

1 row(s) inserted.

Statement 453

insert into moons values ('Jupiter','Kore',1)

1 row(s) inserted.

Statement 454

insert into moons values ('Jupiter','Leda',10)

1 row(s) inserted.

Statement 455

insert into moons values ('Jupiter','Lysithea',18)

1 row(s) inserted.

Statement 456

insert into moons values ('Jupiter','Megaclite',2.7)

1 row(s) inserted.

Statement 457

insert into moons values ('Jupiter','Metis',21.5 )

1 row(s) inserted.

Statement 458

insert into moons values ('Jupiter','Mneme',1)

1 row(s) inserted.

Statement 459

insert into moons values ('Jupiter','Orthosie',1)

1 row(s) inserted.

Statement 460

insert into moons values ('Jupiter','Pasiphae',30)

1 row(s) inserted.

Statement 461

insert into moons values ('Jupiter','Pasithee',1)

1 row(s) inserted.

Statement 462

insert into moons values ('Jupiter','Praxidike',3.4)

1 row(s) inserted.

Statement 463

insert into moons values ('Jupiter','S/2003 J 10',1)

1 row(s) inserted.

Statement 464

insert into moons values ('Jupiter','S/2003 J 12',0.5)

1 row(s) inserted.

Statement 465

insert into moons values ('Jupiter','S/2003 J 15',1)

1 row(s) inserted.

Statement 466

insert into moons values ('Jupiter','S/2003 J 16',1)

1 row(s) inserted.

Statement 467

insert into moons values ('Jupiter','S/2003 J 18',1)

1 row(s) inserted.

Statement 468

insert into moons values ('Jupiter','S/2003 J 19',1)

1 row(s) inserted.

Statement 469

insert into moons values ('Jupiter','S/2003 J 2',1)

1 row(s) inserted.

Statement 470

insert into moons values ('Jupiter','S/2003 J 23',1)

1 row(s) inserted.

Statement 471

insert into moons values ('Jupiter','S/2003 J 3',1)

1 row(s) inserted.

Statement 472

insert into moons values ('Jupiter','S/2003 J 4',1)

1 row(s) inserted.

Statement 473

insert into moons values ('Jupiter','S/2003 J 5',2)

1 row(s) inserted.

Statement 474

insert into moons values ('Jupiter','S/2003 J 9',0.5)

1 row(s) inserted.

Statement 475

insert into moons values ('Jupiter','S/2010 J 1',1)

1 row(s) inserted.

Statement 476

insert into moons values ('Jupiter','S/2010 J 2',0.5)

1 row(s) inserted.

Statement 477

insert into moons values ('Jupiter','S/2011 J 1',0.5)

1 row(s) inserted.

Statement 478

insert into moons values ('Jupiter','S/2011 J 2',0.5)

1 row(s) inserted.

Statement 479

insert into moons values ('Jupiter','Sinope',19)

1 row(s) inserted.

Statement 480

insert into moons values ('Jupiter','Sponde',1)

1 row(s) inserted.

Statement 481

insert into moons values ('Jupiter','Taygete',2.5)

1 row(s) inserted.

Statement 482

insert into moons values ('Jupiter','Thebe',49.3 )

1 row(s) inserted.

Statement 483

insert into moons values ('Jupiter','Thelxinoe',1)

1 row(s) inserted.

Statement 484

insert into moons values ('Jupiter','Themisto',4)

1 row(s) inserted.

Statement 485

insert into moons values ('Jupiter','Thyone',2)

1 row(s) inserted.

Statement 486

insert into moons values ('Mars','Deimos',6.2 )

1 row(s) inserted.

Statement 487

insert into moons values ('Mars','Phobos',11.1 )

1 row(s) inserted.

Statement 488

insert into moons values ('Neptune','Despina',75 )

1 row(s) inserted.

Statement 489

insert into moons values ('Neptune','Galatea',88 )

1 row(s) inserted.

Statement 490

insert into moons values ('Neptune','Halimede',31)

1 row(s) inserted.

Statement 491

insert into moons values ('Neptune','Laomedeia',21)

1 row(s) inserted.

Statement 492

insert into moons values ('Neptune','Larissa',97 )

1 row(s) inserted.

Statement 493

insert into moons values ('Neptune','Naiad',33 )

1 row(s) inserted.

Statement 494

insert into moons values ('Neptune','Nereid',170 )

1 row(s) inserted.

Statement 495

insert into moons values ('Neptune','Neso',30)

1 row(s) inserted.

Statement 496

insert into moons values ('Neptune','Proteus',210 )

1 row(s) inserted.

Statement 497

insert into moons values ('Neptune','Psamathe',20)

1 row(s) inserted.

Statement 498

insert into moons values ('Neptune','S/2004 N 1',8)

1 row(s) inserted.

Statement 499

insert into moons values ('Neptune','Sao',22)

1 row(s) inserted.

Statement 500

insert into moons values ('Neptune','Thalassa',41 )

1 row(s) inserted.

Statement 501

insert into moons values ('Neptune','Triton',1353.4 )

1 row(s) inserted.

Statement 502

insert into moons values ('Pluto','Charon',603.6 )

1 row(s) inserted.

Statement 503

insert into moons values ('Pluto','Hydra',30.5)

1 row(s) inserted.

Statement 504

insert into moons values ('Pluto','Kerberos',6.5)

1 row(s) inserted.

Statement 505

insert into moons values ('Pluto','Nix',23)

1 row(s) inserted.

Statement 506

insert into moons values ('Pluto','Styx',5)

1 row(s) inserted.

Statement 507

insert into moons values ('Saturn','Aegaeon',0.25)

1 row(s) inserted.

Statement 508

insert into moons values ('Saturn','Aegir',3)

1 row(s) inserted.

Statement 509

insert into moons values ('Saturn','Albiorix',16)

1 row(s) inserted.

Statement 510

insert into moons values ('Saturn','Anthe',1)

1 row(s) inserted.

Statement 511

insert into moons values ('Saturn','Atlas',15.3 )

1 row(s) inserted.

Statement 512

insert into moons values ('Saturn','Bebhionn',3)

1 row(s) inserted.

Statement 513

insert into moons values ('Saturn','Bergelmir',3)

1 row(s) inserted.

Statement 514

insert into moons values ('Saturn','Bestla',3.5)

1 row(s) inserted.

Statement 515

insert into moons values ('Saturn','Calypso',9.5 )

1 row(s) inserted.

Statement 516

insert into moons values ('Saturn','Daphnis',3)

1 row(s) inserted.

Statement 517

insert into moons values ('Saturn','Dione',562.5 )

1 row(s) inserted.

Statement 518

insert into moons values ('Saturn','Enceladus',252.3 )

1 row(s) inserted.

Statement 519

insert into moons values ('Saturn','Epimetheus',58.3 )

1 row(s) inserted.

Statement 520

insert into moons values ('Saturn','Erriapus',5)

1 row(s) inserted.

Statement 521

insert into moons values ('Saturn','Farbauti',2.5)

1 row(s) inserted.

Statement 522

insert into moons values ('Saturn','Fenrir',2)

1 row(s) inserted.

Statement 523

insert into moons values ('Saturn','Fornjot',3)

1 row(s) inserted.

Statement 524

insert into moons values ('Saturn','Greip',3)

1 row(s) inserted.

Statement 525

insert into moons values ('Saturn','Hati',3)

1 row(s) inserted.

Statement 526

insert into moons values ('Saturn','Helene',16 )

1 row(s) inserted.

Statement 527

insert into moons values ('Saturn','Hyperion',133.0 )

1 row(s) inserted.

Statement 528

insert into moons values ('Saturn','Hyrrokkin',4)

1 row(s) inserted.

Statement 529

insert into moons values ('Saturn','Iapetus',734.5 )

1 row(s) inserted.

Statement 530

insert into moons values ('Saturn','Ijiraq',6)

1 row(s) inserted.

Statement 531

insert into moons values ('Saturn','Janus',90.4 )

1 row(s) inserted.

Statement 532

insert into moons values ('Saturn','Jarnsaxa',3)

1 row(s) inserted.

Statement 533

insert into moons values ('Saturn','Kari',3.5)

1 row(s) inserted.

Statement 534

insert into moons values ('Saturn','Kiviuq',8)

1 row(s) inserted.

Statement 535

insert into moons values ('Saturn','Loge',3)

1 row(s) inserted.

Statement 536

insert into moons values ('Saturn','Methone',1.6)

1 row(s) inserted.

Statement 537

insert into moons values ('Saturn','Mimas',198.2 )

1 row(s) inserted.

Statement 538

insert into moons values ('Saturn','Mundilfari',3.5)

1 row(s) inserted.

Statement 539

insert into moons values ('Saturn','Narvi',3.5)

1 row(s) inserted.

Statement 540

insert into moons values ('Saturn','Paaliaq',11)

1 row(s) inserted.

Statement 541

insert into moons values ('Saturn','Pallene',2)

1 row(s) inserted.

Statement 542

insert into moons values ('Saturn','Pan',12.8)

1 row(s) inserted.

Statement 543

insert into moons values ('Saturn','Pandora',40.6 )

1 row(s) inserted.

Statement 544

insert into moons values ('Saturn','Phoebe',106.6 )

1 row(s) inserted.

Statement 545

insert into moons values ('Saturn','Polydeuces',1.25)

1 row(s) inserted.

Statement 546

insert into moons values ('Saturn','Prometheus',46.8 )

1 row(s) inserted.

Statement 547

insert into moons values ('Saturn','Rhea',764.5 )

1 row(s) inserted.

Statement 548

insert into moons values ('Saturn','S/2004 S 12',2.5)

1 row(s) inserted.

Statement 549

insert into moons values ('Saturn','S/2004 S 13',3)

1 row(s) inserted.

Statement 550

insert into moons values ('Saturn','S/2004 S 17',2)

1 row(s) inserted.

Statement 551

insert into moons values ('Saturn','S/2004 S 7',3)

1 row(s) inserted.

Statement 552

insert into moons values ('Saturn','S/2006 S 1',3)

1 row(s) inserted.

Statement 553

insert into moons values ('Saturn','S/2006 S 3',3)

1 row(s) inserted.

Statement 554

insert into moons values ('Saturn','S/2007 S 2',3)

1 row(s) inserted.

Statement 555

insert into moons values ('Saturn','S/2007 S 3',3)

1 row(s) inserted.

Statement 556

insert into moons values ('Saturn','S/2009 S 1',0.15)

1 row(s) inserted.

Statement 557

insert into moons values ('Saturn','Siarnaq',20)

1 row(s) inserted.

Statement 558

insert into moons values ('Saturn','Skathi',4)

1 row(s) inserted.

Statement 559

insert into moons values ('Saturn','Skoll',3)

1 row(s) inserted.

Statement 560

insert into moons values ('Saturn','Surtur',3)

1 row(s) inserted.

Statement 561

insert into moons values ('Saturn','Suttungr',3.5)

1 row(s) inserted.

Statement 562

insert into moons values ('Saturn','Tarqeq',3.5)

1 row(s) inserted.

Statement 563

insert into moons values ('Saturn','Tarvos',7.5)

1 row(s) inserted.

Statement 564

insert into moons values ('Saturn','Telesto',12 )

1 row(s) inserted.

Statement 565

insert into moons values ('Saturn','Tethys',536.3 )

1 row(s) inserted.

Statement 566

insert into moons values ('Saturn','Thrymr',3.5)

1 row(s) inserted.

Statement 567

insert into moons values ('Saturn','Titan',2575.5 )

1 row(s) inserted.

Statement 568

insert into moons values ('Saturn','Ymir',9)

1 row(s) inserted.

Statement 569

insert into moons values ('Uranus','Ariel',578.9 )

1 row(s) inserted.

Statement 570

insert into moons values ('Uranus','Belinda',40.3 )

1 row(s) inserted.

Statement 571

insert into moons values ('Uranus','Bianca',25.7 )

1 row(s) inserted.

Statement 572

insert into moons values ('Uranus','Caliban',49)

1 row(s) inserted.

Statement 573

insert into moons values ('Uranus','Cordelia',20.1 )

1 row(s) inserted.

Statement 574

insert into moons values ('Uranus','Cressida',39.8 )

1 row(s) inserted.

Statement 575

insert into moons values ('Uranus','Cupid',5)

1 row(s) inserted.

Statement 576

insert into moons values ('Uranus','Desdemona',32.0 )

1 row(s) inserted.

Statement 577

insert into moons values ('Uranus','Ferdinand',6)

1 row(s) inserted.

Statement 578

insert into moons values ('Uranus','Francisco',6)

1 row(s) inserted.

Statement 579

insert into moons values ('Uranus','Juliet',46.8 )

1 row(s) inserted.

Statement 580

insert into moons values ('Uranus','Mab',5)

1 row(s) inserted.

Statement 581

insert into moons values ('Uranus','Margaret',5.5)

1 row(s) inserted.

Statement 582

insert into moons values ('Uranus','Miranda',235.8 )

1 row(s) inserted.

Statement 583

insert into moons values ('Uranus','Oberon',761.4 )

1 row(s) inserted.

Statement 584

insert into moons values ('Uranus','Ophelia',21.4 )

1 row(s) inserted.

Statement 585

insert into moons values ('Uranus','Perdita',10)

1 row(s) inserted.

Statement 586

insert into moons values ('Uranus','Portia',67.6 )

1 row(s) inserted.

Statement 587

insert into moons values ('Uranus','Prospero',15)

1 row(s) inserted.

Statement 588

insert into moons values ('Uranus','Puck',81 )

1 row(s) inserted.

Statement 589

insert into moons values ('Uranus','Rosalind',36 )

1 row(s) inserted.

Statement 590

insert into moons values ('Uranus','Setebos',15)

1 row(s) inserted.

Statement 591

insert into moons values ('Uranus','Stephano',10)

1 row(s) inserted.

Statement 592

insert into moons values ('Uranus','Sycorax',75)

1 row(s) inserted.

Statement 593

insert into moons values ('Uranus','Titania',788.9 )

1 row(s) inserted.

Statement 594

insert into moons values ('Uranus','Trinculo',5)

1 row(s) inserted.

Statement 595

insert into moons values ('Uranus','Umbriel',584.7 )

1 row(s) inserted.

Statement 596

commit

Statement processed.

Statement 597

select planet_name, name, radius,  
       row_number() over ( order by radius desc) as size_rank
from   moons
where  planet_name in ('Earth','Mars','Saturn')
and    row_number() over ( order by radius desc) <= 3

ORA-30483: window  functions are not allowed here

More Details: https://docs.oracle.com/error-help/db/ora-30483

Statement 598

select *
from (
  select planet_name, name, radius,  
         row_number() over ( order by radius desc) as size_rank
  from   moons
  where  planet_name in ('Earth','Mars','Saturn')
)
where size_rank <= 3

 
PLANET_NAME NAME RADIUS SIZE_RANK
Saturn Titan 2575.5 1
Earth Moon 1737.1 2
Saturn Rhea 764.5 3

3 rows selected.

Analytics - How to apply predicates

Additional Information