I gang

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.

Færdigheder: Database Administration, MySQL, PHP, SQL

Se mere: 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, sign mysql query, showtimes, show mysql query, php showtimes, php show queries

Om arbejdsgiveren:
( 6 bedømmelser ) Kfar Saba, Israel

Projekt-ID: #5810428

4 freelancers are bidding on average $33 for this job

LearningNew

A proposal has not yet been provided

$49 USD på 1 dag
(63 bedømmelser)
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 på 1 dag
(13 bedømmelser)
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 in 0 dage
(17 bedømmelser)
5.3
proknob

A proposal has not yet been provided

$25 USD på 1 dag
(0 bedømmelser)
0.0