Modern Tempo Spells Winrate Analysis

I'll analyze the best performing non-creature cards in Modern over the last month. Let me start by getting the Modern format data and then query for non-creature cards with performance data.

Let me fix the SQL query by restructuring it properly:

The query returned no results. Let me try a different approach and first check what card types we have, then look at the most popular non-creature, non-land cards:

Great! Now I can see the most played cards. Let me filter for non-creature spells and then calculate their winrates. I need to identify which of these are non-creatures:

Perfect! Now let me calculate the winrates for these non-creature spells. I'll query for the top non-creature cards and their performance:

Let me try a simpler approach and get some sources first to see what data we have:

Let me try a different approach to calculate card winrates. I'll use a simpler query structure:

Let me check what's happening by looking at the basic tournament data structure:

Good, we have tournament data. Let me try a different approach and check matches table structure:

I see the issue - the match results are not stored as 'W'/'L'. Let me check what values are actually in the result field:

Perfect! Now I can get the correct winrates. Let me query for the top non-creature spells by winrate:

Let me check if the card names are case-sensitive and also expand to more non-creature spells:

Great! Now let me get their winrates:

Perfect! Now I have the data I need. Let me also get sources to provide context: