instruction: C# Gold bearers from India.
response: WITH data AS (SELECT RANK() OVER (PARTITION BY b.UserId ORDER BY b.Date) AS rn, b.UserId, b.Date FROM Badges AS b WITH (nolock) WHERE b.Name = 'asp.net') SELECT ROW_NUMBER() OVER (ORDER BY Date) AS Number, u.DisplayName, data.Date, CASE rn WHEN 1 THEN 'bronze' WHEN 2 THEN 'silver' WHEN 3 THEN 'gold' END AS badge FROM data JOIN Users AS u WITH (nolock) ON data.UserId = u.Id WHERE rn = 1 AND LOWER(u.Location) LIKE LOWER('%india') ORDER BY Date