Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit986250d

Browse files
authored
Improved tasks 1327, 1341, 1378
1 parenta202231 commit986250d

File tree

15 files changed

+11
-552
lines changed

15 files changed

+11
-552
lines changed

‎src.save/main/java/g1301_1400/s1327_list_the_products_ordered_in_a_period/script.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# Write your MySQL query statement below
2-
# #Easy #Database #2023_08_15_Time_1355_ms_(82.29%)_Space_0B_(100.00%)
2+
# #Easy #Database #2023_08_16_Time_1374_ms_(80.18%)_Space_0B_(100.00%)
33
SELECT*FROM (
44
SELECT
55
a.product_name,

‎src.save/main/java/g1301_1400/s1341_movie_rating/script.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# Write your MySQL query statement below
2-
# #Medium #Database #2023_08_15_Time_2843_ms_(48.31%)_Space_0B_(100.00%)
2+
# #Medium #Database #2023_08_16_Time_2515_ms_(78.94%)_Space_0B_(100.00%)
33
(SELECT name results
44
FROM Usersas U, MovieRatingas MR
55
WHEREU.user_id=MR.user_id

‎src.save/main/java/g1301_1400/s1378_replace_employee_id_with_the_unique_identifier/script.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# Write your MySQL query statement below
2-
# #Easy #Database #2023_08_15_Time_2747_ms_(40.02%)_Space_0B_(100.00%)
2+
# #Easy #Database #2023_08_16_Time_2498_ms_(63.60%)_Space_0B_(100.00%)
33
selectu.unique_id,e.name
44
from Employees e
55
left join EmployeeUNI u

‎src.save/test/java/g1301_1400/s1327_list_the_products_ordered_in_a_period/MysqlTest.java‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -67,8 +67,8 @@ void testScript(@EmbeddedDatabase DataSource dataSource)
6767
newBufferedReader(
6868
newFileReader(
6969
"src/main/java/g1301_1400/"
70-
+"s1327_list_the_products_"
71-
+"ordered_in_a_period/script.sql"))
70+
+"s1327_list_the_products_ordered_"
71+
+"in_a_period/script.sql"))
7272
.lines()
7373
.collect(Collectors.joining("\n"))
7474
.replaceAll("#.*?\\r?\\n",""))) {

‎src.save/test/java/g1301_1400/s1341_movie_rating/MysqlTest.java‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -36,8 +36,8 @@
3636
+" VALUES (3, 'Maria'); "
3737
+"INSERT INTO Users(user_id, name)"
3838
+" VALUES (4, 'James'); "
39-
+"CREATE TABLE MovieRating(movie_id INTEGER, user_id INTEGER,"
40-
+"rating INTEGER, created_at DATE); "
39+
+"CREATE TABLE MovieRating(movie_id INTEGER, user_id INTEGER,"
40+
+"rating INTEGER, created_at DATE); "
4141
+"INSERT INTO MovieRating(movie_id, user_id, rating, created_at)"
4242
+" VALUES (1, 1, 3, '2020-01-12'); "
4343
+"INSERT INTO MovieRating(movie_id, user_id, rating, created_at)"
@@ -66,8 +66,8 @@ void testScript(@EmbeddedDatabase DataSource dataSource)
6666
statement.executeQuery(
6767
newBufferedReader(
6868
newFileReader(
69-
"src/main/java/g1301_1400/s1341_movie_rating"
70-
+"/script.sql"))
69+
"src/main/java/g1301_1400/"
70+
+"s1341_movie_rating/script.sql"))
7171
.lines()
7272
.collect(Collectors.joining("\n"))
7373
.replaceAll("#.*?\\r?\\n",""))) {

‎src.save/test/java/g1301_1400/s1378_replace_employee_id_with_the_unique_identifier/MysqlTest.java‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -49,8 +49,8 @@ void testScript(@EmbeddedDatabase DataSource dataSource)
4949
newBufferedReader(
5050
newFileReader(
5151
"src/main/java/g1301_1400/"
52-
+"s1378_replace_employee_id_with_"
53-
+"the_unique_identifier/script.sql"))
52+
+"s1378_replace_employee_id_with"
53+
+"_the_unique_identifier/script.sql"))
5454
.lines()
5555
.collect(Collectors.joining("\n"))
5656
.replaceAll("#.*?\\r?\\n",""))) {

‎src/main/java/g1301_1400/s1327_list_the_products_ordered_in_a_period/readme.md‎

Lines changed: 0 additions & 85 deletions
This file was deleted.

‎src/main/java/g1301_1400/s1327_list_the_products_ordered_in_a_period/script.sql‎

Lines changed: 0 additions & 14 deletions
This file was deleted.

‎src/main/java/g1301_1400/s1341_movie_rating/readme.md‎

Lines changed: 0 additions & 101 deletions
This file was deleted.

‎src/main/java/g1301_1400/s1341_movie_rating/script.sql‎

Lines changed: 0 additions & 13 deletions
This file was deleted.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp