/
Dplyr-link-to-databases-R-SQL.txt
76 lines (65 loc) · 1.61 KB
/
Dplyr-link-to-databases-R-SQL.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
PART 1:
Source: query [?? x 4]
Database: sqlite 3.8.6 [portal_mammals.sqlite]
year month day species_id
<int> <int> <int> <chr>
1 1977 7 16 NL
2 1977 7 16 NL
3 1977 7 16 DM
4 1977 7 16 DM
5 1977 7 16 DM
6 1977 7 16 PF
7 1977 7 16 PE
8 1977 7 16 DM
9 1977 7 16 DM
10 1977 7 16 PF
# ... with more rows
————————————————————
PART 2:
Source: query [?? x 3]
Database: sqlite 3.8.6 [portal_mammals.sqlite]
year species_id weight_kg
<int> <chr> <dbl>
1 1977 DM 0.040
2 1977 DM 0.048
3 1977 DM 0.029
4 1977 DM 0.046
5 1977 DM 0.036
6 1977 DO 0.052
7 1977 PF 0.008
8 1977 OX 0.022
9 1977 DM 0.035
10 1977 PF 0.007
# ... with more rows
————————————————————
PART 3 (both of these are acceptable answers):
Source: query [?? x 1]
Database: sqlite 3.8.6 [portal_mammals.sqlite]
species_id
<chr>
1 DM
2 DO
3 PF
4 OX
5 PP
6 PE
7 OT
8 OL
9 RM
10 DS
# ... with more rows
Source: lazy query [?? x 1]
Database: sqlite 3.8.6 [portal_mammals.sqlite]
species_id
<chr>
1 BA
2 DM
3 DO
4 DS
5 NL
6 OL
7 OT
8 OX
9 PB
10 PE
# ... with more rows