MicroStrategy (MSTR) ¿ë¾î
¸ÅÆ®¸¯ : COUNT(SALE_KEY) AS ¸ÅÃâ°Ç¼ö, SUM(SALE_AMT) AS ¸ÅÃâ¾×
ÆÑÆ® : SALE_KEY, SALE_AMT
¾îÆ®¸®ºäÆ® : STORE_CD AS Á¡ (GROUP BY)
ÇÊÅÍ : SALE_DATE
MicroStrategy (MSTR) ¿ë¾î
¸ÅÆ®¸¯ : COUNT(SALE_KEY) AS ¸ÅÃâ°Ç¼ö, SUM(SALE_AMT) AS ¸ÅÃâ¾×
ÆÑÆ® : SALE_KEY, SALE_AMT
¾îÆ®¸®ºäÆ® : STORE_CD AS Á¡ (GROUP BY)
ÇÊÅÍ : SALE_DATE