Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
CREATE TABLE Blood_Donations( id INT, date text, DonorID INT PRIMARY KEY, name VARCHAR(50), age INT CHECK(age>0), bloodtype VARCHAR(3), branch CHAR(6), amount_donated INT, number_of_donations INT ); INSERT INTO Blood_Donations VALUES (1, '02 December 2020', 0028, 'Calvin Perks', 36, 'A-', 'Harare', 362, 4), (2, '02 December 2020', 0145, 'Lisa Dorothy', 28, 'B+', 'Harare', 367, 5), (3, '02 December 2020', 0063, 'Brian Denver', 24, 'AB-', 'Harare', 364, 9), (4, '02 December 2020', 0097, 'Stella Leftner', 31, 'A-', 'Harare', 377, 6), (5, '02 December 2020', 0134, 'Brilliant Lenovo', 44, 'O+', 'Harare', 406, 14), (6, '03 December 2020', 0004, 'Sandra Sibina', 32, 'O+', 'Harare', 356, 7), (7, '03 December 2020', 0086, 'Obriel Montez', 26, 'B-', 'Harare', 422, 3), (8, '03 December 2020', 0045, 'Natasha Forbs', 38, 'O-', 'Harare', 384, 6), (9, '04 December 2020', 0208, 'Marie Antebellum', 22, 'A+', 'Harare', 431, 1), (10, '04 December 2020', 0041, 'Stanley Madagascar', 24, 'AB+', 'Harare', 412, 11); SELECT SUM(amount_donated) FROM Blood_Donations WHERE date = '02 December 2020'; SELECT id, date, DonorID, name, age, bloodtype, branch, amount_donated, number_of_donations FROM Blood_Donations ORDER BY date Desc; SELECT * FROM Blood_Donations WHERE name like 'B%'; SELECT * FROM Blood_Donations WHERE name like '%b%'
absolute service time: 0,46 sec
fork mode
|
history
|
discussion
sum
1
1876
id
date
donorid
name
age
bloodtype
branch
amount_donated
number_of_donations
1
9
04 December 2020
208
Marie Antebellum
22
A+
Harare
431
1
2
10
04 December 2020
41
Stanley Madagascar
24
AB+
Harare
412
11
3
6
03 December 2020
4
Sandra Sibina
32
O+
Harare
356
7
4
7
03 December 2020
86
Obriel Montez
26
B-
Harare
422
3
5
8
03 December 2020
45
Natasha Forbs
38
O-
Harare
384
6
6
1
02 December 2020
28
Calvin Perks
36
A-
Harare
362
4
7
3
02 December 2020
63
Brian Denver
24
AB-
Harare
364
9
8
2
02 December 2020
145
Lisa Dorothy
28
B+
Harare
367
5
9
4
02 December 2020
97
Stella Leftner
31
A-
Harare
377
6
10
5
02 December 2020
134
Brilliant Lenovo
44
O+
Harare
406
14
id
date
donorid
name
age
bloodtype
branch
amount_donated
number_of_donations
1
3
02 December 2020
63
Brian Denver
24
AB-
Harare
364
9
2
5
02 December 2020
134
Brilliant Lenovo
44
O+
Harare
406
14
id
date
donorid
name
age
bloodtype
branch
amount_donated
number_of_donations
1
6
03 December 2020
4
Sandra Sibina
32
O+
Harare
356
7
2
7
03 December 2020
86
Obriel Montez
26
B-
Harare
422
3
3
8
03 December 2020
45
Natasha Forbs
38
O-
Harare
384
6
4
9
04 December 2020
208
Marie Antebellum
22
A+
Harare
431
1