生成 SQL 查询以统计上个月的唯一登录次数并对其进行排序
在对 Cloud 控制台使用不同参数值时,或通过直接调用 Vertex AI API,您可以直接查询模型,并测试返回的结果。
|
|||||||||||
提示自由格式"Consider a table with schema as described below. ' Column name - Description ' Username - username of the user logging in ' LicenseType - Either ""MultiUse"" or ""SingleUse"" ' LoginTime - The datetime of the login event As data analysis expert, please write a SQL query to show me the list of users, their license types and the number of unique days on which the user logged in for the last 3 calendar months. Sort it by highest count of logins in a month to the lowest count of logins in a month." 响应```sql WITH MonthlyLogins AS ( SELECT Username, LicenseType, DATE(LoginTime) AS LoginDate FROM YourTable WHERE LoginTime BETWEEN DATE('now', '-3 months') AND DATE('now') ), UniqueLoginDays AS ( SELECT Username, LicenseType, COUNT(DISTINCT LoginDate) AS UniqueLoginDays FROM MonthlyLogins GROUP BY Username, LicenseType ) SELECT Username, LicenseType, UniqueLoginDays FROM UniqueLoginDays ORDER BY UniqueLoginDays DESC; ``` |
|