What is the hierarchy in a web studio company?

Question

Business Informatics

Hello, help me create a hierarchy for a web studio company
Needed for term paper
Preferably by the type of scheme: link
but specifically for a studio from 2016)

Answer 1

From such an abundance of leaders involuntarily remembered macode.ru

Answer 2

well, this is your term paper, how do we know the hierarchy of your studio in your head.

Answer 3

You would at least indicate the approximate number.
For example, there are very small web studios: a web designer, a CMS coder, a client manager, a content manager. Some of them are also a part-time general director, and the accounting department is remote.
And there are huge web studios, a large IT department headed by the director, who has programmers in various areas, system administrators, etc. Separately, designers are subordinate to the art director.
Sales department, SEOs, advertisers. Separately, accounting under the leadership of the chief accountant. I'm not talking about cleaners, watchmen, plumbers

Answer 4

1) convert date to DATE! no options at all
2)

select
price.*, tovar.tovar_name
from price
join tovar on tovar.tovar_id = price.tovar_id
where price.date = (select MAX(price2.date) from price as price2 where price2.tovar_id=price.tovar_id )
order by price.price

Without a subquery, I can't think of one right off the bat.
but in any case, this is a perversion and a very slow request, get yourself another plate where the current price is stored.

Answer 5

SELECT p.*, t.tovar_name
FROM price p
INNER JOIN tovar t ON t.id = p.tovar_id
INNER JOIN (SELECT id, MAX(date) AS max_date FROM price GROUP BY tovar_id) AS max_price ON max_price.id = p.id AND max_price.max_date = p.date
ORDER BY p.price