fork download
copy 
  1. create view my_view as
  2. select отдел, количество_сотрудников
  3. from сотрудники
  4. where отдел = "Продаж" and должность <> "Нач отдела" or отдел = "Маркетинга" and должность <> "Нач отдела";
  5.  
Success #stdin #stdout 0s 4408KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/osDA52
language:
SQLite (sqlite 3.27.2)
created:
4 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!