/usr/share/doc/r-cran-dbplyr/tests/testthat/_snaps/verb-count.md

# generates expected SQL for common situations

    Code
      db %>% count(g)
    Output
      <SQL>
      SELECT `g`, COUNT(*) AS `n`
      FROM `df`
      GROUP BY `g`

---

    Code
      db %>% count(g, wt = x)
    Output
      <SQL>
      SELECT `g`, SUM(`x`) AS `n`
      FROM `df`
      GROUP BY `g`

---

    Code
      db %>% count(g, sort = TRUE)
    Output
      <SQL>
      SELECT `g`, COUNT(*) AS `n`
      FROM `df`
      GROUP BY `g`
      ORDER BY `n` DESC

---

    Code
      db %>% add_count(g, sort = TRUE)
    Output
      <SQL>
      SELECT *, COUNT(*) OVER (PARTITION BY `g`) AS `n`
      FROM `df`
      ORDER BY `n` DESC

---

    Code
      db %>% group_by(g) %>% add_count()
    Output
      <SQL>
      SELECT *, COUNT(*) OVER (PARTITION BY `g`) AS `n`
      FROM `df`

# .drop is not supported

    Code
      lazy_frame(g = 1) %>% add_count(.drop = TRUE)
    Condition
      Error in `add_count()`:
      ! `.drop` argument not supported for lazy tables.

Generated by dwww version 1.15 on Tue Jul 2 08:47:47 CEST 2024.