Changes between Version 9 and Version 10 of querries


Ignore:
Timestamp:
09/24/25 16:06:35 (13 days ago)
Author:
221046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • querries

    v9 v10  
    3838!MaxPlayCounts=γgenre_id,MAX(play_count)→max_count​(!PlayCounts)
    3939
    40 Final_Result=π pc.genre_name,pc.artist_name,pc.play_count(PlayCounts⋈pc.genre_id=mpc.genre_id∧pc.play_count=mpc.max_count !MaxPlayCounts)
     40Final_Result=π pc.genre_name,pc.artist_name,pc.play_count(!PlayCounts⋈pc.genre_id=mpc.genre_id∧pc.play_count=mpc.max_count !MaxPlayCounts)
     41
     42
     43πpc.genre_name,pc.artist_name,pc.play_count​((γg.genre_id,g.name→genre_name,ar.name→artist_name,COUNT(∗)→play_count​(σc.customer_id=123​((customer⋈invoice)⋈(invoice_line⋈track)⋈(track⋈genre)⋈(track⋈album)⋈(album⋈artist))))⋈pc.genre_id=mpc.genre_id∧pc.play_count=mpc.max_count​(γgenre_id,MAX(play_count)→max_count​(!PlayCounts))
    4144
    4245** ← [wiki: Назад на почетна] **