Käynnissä

Write SQL queries

Hello,

Require a person who deals in databases with high knowledge for writing complex queries.

All info in the files. with the 3 tables . sql file

I need the person write to me 2 sql queries.

query one: search on showtimes where the movieID is what i give him for example 88, then i show me only 3 Thearters are show time movie. i need the dates from showtimes broken by sign # like

vtid (theaterID) | vt_name (theaterName) | vs_dates (times)

6 | some name | 1222222#1333333#144444

7 | other theater | 1222222#13113333#141144

9 | other theater2 | 1222442#133113#143344

i added photos just watch them.

query two:

same search but with TheaterID.. not movieid like first.

Taidot: Tietokannan hallinto, MySQL, PHP, SQL

Näytä lisää: Writing SQL Queries, write query, sql queries, queries, mysql to sql, php sql complex, php mysql sql example, write sql queries, movie write, mysql query example, mysql php search dates, sql file, write sql , complex mysql query, write photos, write time file, tree queries sql, sql write time project, sql write back excel addin, sql movie theater

Tietoa työnantajasta:
( 6 arvostelua ) Kfar Saba, Israel

Projektin tunnus: #5810428

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

LearningNew

A proposal has not yet been provided

$49 USD 1 päivässä
(63 arvostelua)
6.8
eduardocubel

Hello, I have availability to start your job as soon as possible. Feel free to chat me and see details. If you have any question, please feel free to ask me. Yours Sincerely, Eduardo

$29 USD 1 päivässä
(13 arvostelua)
6.4
seventyoneways

Can complete it immediately. Payment can be made via milestone and you can complete it after testing the solution fully on your machine. Looking forward to hearing from you

$30 USD 0 päivässä
(17 arvostelua)
5.3
proknob

A proposal has not yet been provided

$25 USD 1 päivässä
(0 arvostelua)
0.0