The Symphony Prof. Greenberg-Fine Arts & Music

Jovan Stosic December 28, 2021

Average 45 minutes each

1
Let’s Take It From the Top!

2
The Concerto and the Orchestra

3
The Pre-Classical Symphony

4
Mannheim

5
Classical Masters

6
Franz Joseph Haydn, Part 1

7
Franz Joseph Haydn, Part 2

8
Mozart

9
Beethoven

10
Schubert

11
Berlioz and the Symphonie fantastique

12
Mendelssohn and Schumann

13
Franck, Saint-Saens, and the Symphony in France

14
Nationalism and the Symphony

15
Brahms, Bruckner, and the Viennese Symphony

16
Gustav Mahler

17
Nielsen and Sibelius

18
The Symphony in Russia

19
Charles Ives

20
Aaron Copland and Samuel Barber

21
Roy Harris and William Schuman

22
The Twentieth-Century British Symphony

23
Olivier Messiaen and Turangalila!

24
Dmitri Shostakovich and His Tenth Symphony

 

Source: The Symphony Prof. Greenberg-Fine Arts & Music

TTC – Chamber Music of Mozart – Online Study of Mozart

Jovan Stosic December 28, 2021

1
A Blessing of Inconceivable Richness

2
“The Hunt”

3
“The Hunt,” Part 2

4
The Flute Quartet in D Major

5
Vienna

6
Haydn and Inspiration

7
Exclusively For His Friends

8
Duos For Violin and Viola

9
Not Just a Pretty Face

10
Blowin’ in the Winds

11
The Piano Trios

12
The Piano Quartets

13
String Quartet in A Major, K. 464

14
The String Quintets

15
Dissonance—Musical and Financial

16
Basset Horns and Harmonicas
Source: Chamber Music of Mozart – Online Study of Mozart

How to Find Duplicate Values in a SQL Table | Tutorial by Chartio

Jovan Stosic December 28, 2021

Write Query to Verify Duplicates Exist

The first query we’re going to write is a simple query to verify whether duplicates do indeed exist in the table. For our example, my query looks like this:

SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1

HAVING is important here because unlike WHERE, HAVING filters on aggregate functions.

If any rows are returned, that means we have duplicates. In this example, our results look like this:

USERNAME EMAIL COUNT
Pete pete@example.com 2
Jessica jessica@example.com 2
Miles miles@example.com 2

List All Rows Containing Duplicates

In the previous step, our query returned a list of duplicates. Now, we want to return the entire record for each duplicate row.

To accomplish this, we’ll need to select the entire table and join that to our duplicate rows. Our query looks like this:

SELECT a.*
FROM users a
JOIN (SELECT username, email, COUNT(*)
FROM users 
GROUP BY username, email
HAVING count(*) > 1 ) b
ON a.username = b.username
AND a.email = b.email
ORDER BY a.email

If you look closely, you’ll see that this query is not so complicated. The initial SELECT simply selects every column in the users table, and then inner joins it with the duplicated data table from our initial query. Because we’re joining the table to itself, it’s necessary to use aliases (here, we’re using a and b) to label the two versions.

Here is what our results look like for this query:

ID USERNAME EMAIL
1 Pete pete@example.com
6 Pete pete@example.com
12 Jessica jessica@example.com
13 Jessica jessica@example.com
2 Miles miles@example.com
9 Miles miles@example.com

Because this result set includes all of the row ids, we can use it to help us deduplicate the rows later.

Source: How to Find Duplicate Values in a SQL Table | Tutorial by Chartio