Query sql mobile database jobs

...an internal business tool/website. A very BASIC MS SQL schema will be provided for Functionality to interact with. The project includes: The development of a lightweight css, jquery design that is simplistic but still looks ok. Static Pages - Home - Contact Us - About Us Functionality Pages - User Registration - User Login - User self management) - Password reset via email. - User Management admin The sample should show, connecting to an ms sql database. Displaying data through a non defined data source eg (a query enbeded in the code) as well as a defined Datasource. The site should use headers and footers. VS2022, has a sample site, it could be possible to simply use that and make the 'users' logging in / connecting to the database...

I am looking for a seasoned Oracle Apex developer with a knack for artistic flair to develop a unique user interface for our new application. Specifically, your role will revolve around: • Leveraging SQL to create an aesthetically pleasing, functional user interface that aligns with Oracle APEX principles. • Leveraging your design prowess to develop an artistic, visually-engaging user interface. Your competencies should include: • Proven proficiency in Oracle APEX and SQL • A portfolio showcasing previous user interface designs, ideally within the Oracle APEX framework • A keen eye for artistic, visually pleasing design aesthetics • Superb problem-solving abilities while working within design constraints. Prior experience developing simila...

...customer service aspect of my business and to take charge of a small database (containing up to 1,000 records). Key responsibilities will include: - Customer Service: Responding to client enquiries, resolving user issues, and maintaining high customer satisfaction levels. - Database Management: Handling information pertinent to the customer service role, conducting regular updates, ensuring record accuracy, managing data privacy, and maintaining overall data integrity. The ideal candidate would have: - Prior experience in a customer service position, demonstrating excellent communication and problem-solving skills. - Proficiency in database management, more specifically with small scale databases. Knowledge of database software will be an added advantage....

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this proj...

I am seeking a Java expert to build a simple and efficient Java Servlet application that will seamlessly connect to my Oracle 19c database via JDBC. Key requirements for the project: - A Java Servlet application tailored to connect to Oracle 19c database - The application should be able to execute both read and write operations on the database. - The solution should be robust, secure, and optimized for performance Ideal candidate for this project should have: - Proven experience with developing Java Servlet applications - Strong background in working with Oracle databases - Proficiency in JDBC and database management - Familiarity with database read and write operations - Ability to deliver a high quality, efficient and well-documented solution

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

We have an internal database with about 2000 European investor profiles from the last 20 years. I'm looking for a skilled developer to integrate OpenAI GPT to allow users to search for suitable investors in our database without needing to input a specific format, but normal text. the GPT then translates this text into a format of our database and based on a matching / scoring algorithm will select the best 10 investors for our set of 2000. The user should be able to go on our website. ask a question leave an email and get an answer with the top 10 list as an email attachment. That person needs to leave his contact details which will be automatically added to our Zoho CRM with a trigger action to setup a call for one of our sales people. Key Project Details: - ...

I have UI design for React Native I need prototype using React Native.

I aim to create a music blog using WordPress, focusing on showcasing different genres and providing readers with insightful articles. Since this platform is not designed for music streaming, key elements will be centered around content...is blogging, ideally, freelancers should: - Have experience designing WordPress websites, particularly blogs - Understand the music industry to some degree - Be able to incorporate engaging visuals that suit the music theme - Possess SEO understanding to optimize blog posts for search engines - Demonstrate creativity in designing user-friendly layouts and easy navigation Though I skipped the query about the main features, I’m open to any suggestions that could enhance the blog's effectiveness, keeping readers' interests and continu...

Error establishing a database connection This either means that the username and password information in your file is incorrect or that contact with the database server at localhost could not be established. This could mean your host’s database server is down. Are you sure you have the correct username and password? Are you sure you have typed the correct hostname? Are you sure the database server is running? If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

...Microsoft Power Apps. This app will primarily serve as a data entry tool (and basic data analysis) for the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionality to add a new expense. There sh...

In search of a seasoned app developer who can design and develop sophisticated mobile applications for both iOS and Android platforms. I am looking for: - Expertise in generating a modern, clean look for the app - Proven track record developing apps with integrated e-commerce functionality Your skills and experience should ideally encompass: - Strong background in both iOS and Android development - Proficiency in creating stylish, modern app designs - Extensive experience in incorporating e-commerce features in apps - Conducting thorough testing and debugging to ensure optimal performance and user experience. - Good understanding of user-oriented design principles - Ability to work independently and manage your own schedule effectively - Attention to detail and a commitment to...

As you can see, we are seeking an experienced mobile app developer to help us build a syllabus organization app for Android platform. Key functionalities: * Course organizer: The app should allow users to view pdf syallabus without the right to print or screenshot. Ideal Applicant: * Developers with substantial experience in mobile app development, especially on Android platform. Your application should showcase your long-standing experience in the field. In your application, please include: * Your portfolio demonstrating your past app development projects. * A description of your professional experience. * How you approach and resolve challenges during app development. We are striving for a simple yet effective application, so user-experience should be at the forefront...

I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.

I'm in need of a talented mobile app developer to create a robust application that will work seamlessly on both Android and IOS platforms. Key Requirements: - The app is primarily focused on Maps and Location services. It should have all the necessary functionalities and interactions that are expected from a location-based app. Other Key Information: - The app will not require user authentication. It should be easily accessible and usable without the need for users to create an account or log in. Ideal Skills and Experience: - Proficiency in creating cross-platform mobile apps, with a focus on Maps and Location services. - Experience with developing apps that do not require user authentication. - Familiarity with integrating external services and APIs, particularly ...

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows t...row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient in PostgreSQL and SQL scripting. - Experience in writing complex queries and scripts for data manipulation. - Ability to understand and implement static conditions within a loop. - Clear communication to confirm understanding of the specific requirements and ensure the script meets the necessar...

...keep alumni informed about upcoming reunions, workshops, and networking events. Build and integrate systems for RSVPs and ticketing to streamline event attendance and management. - Quality and Performance: Ensure the application's performance is top-notch, debug issues, and maintain smooth operation. - Security and Compliance: Integrate modern authentication mechanisms and ensure the app meets mobile standards for app store approvals. Required Skills: - Flutter Mastery: Proven track record in Flutter development, ready to handle everything from the ground up. - Dart Proficiency: Strong command of Dart and its nuances. - API and Data Integration: Experience with API integration and a deep understanding of RESTful services. - State Management: Familiarity with state management...

I'm in need of a React Native developer for a mobile app I'm working on. The app aims to provide a solid structure, making it easy for users to navigate and interact with the content. Key Requirements: - Mobile App Development Experience: You should have a strong portfolio demonstrating your ability to create engaging and user-friendly mobile applications. - React Native Expertise: Proficiency in React Native is a must. You should be able to handle both iOS and Android apps with ease. - Strong UI/UX Focus: I'm looking for someone who understands the importance of good design and can create a visually appealing and intuitive user interface. - Attention to Detail: The app structure should be well thought out and implemented, ensuring a smooth user experi...

I'm in need of a talented developer proficient in...talented developer proficient in VB6 application conversion to both iOS and Android platforms. The main task will involve modernizing a data analysis VB6 application, bringing it to a mobile platform while preserving its core functions and unique aspects. Key tasks: - Convert VB6 application to a hybrid mobile app for both iOS and Android. - Please make an educated suggestion about what should be preserved since I didn't indicate specific features from the original VB6 app. - The application's primary purpose is data analysis, which needs to shine in the mobile version. Ideal skills: - Proficient in VB6 and mobile app development. - Good understanding of data analysis applications. - Nice to ha...

I need a well-structured informational website built. Although it won't be focused on e-commerce, I plan on featuring over a 100 products to keep my users informed about my collection. Therefore, a comprehensive database to catalog these items is essential. The ideal candidate would have: - Proven experience in website creation with a focus on data presentation - Ability to design intuitive UI/UX - SQL or similar database management skills - Strong attention to detail as accurate presentation of all product information is crucial - Experience with JavaScript, CSS and HTML - SEO optimization knowledge is a plus. The timeline for completion is to be discussed. Please include examples of similar projects you've completed in your proposal.

: logo with display menu: select option: Subdomains Directories sensitive parameters 4. SQL Testing 5. xss Testing 1- : (use this open source code) Options: -d, --domain: Specify the target domain. -b, --bruteforce: Enable subdomain bruteforcing. -o, --output: Specify the output file path. -h, --help: Display help information. example subdomain -d -o /home/Desktop/ This option leverages various search engines like Google, Bing, Yahoo, DNSDumpster, VirusTotal, SSL, etc., to discover subdomains associated with the target domain. 2- find Directories: (use this open source code) Options: -u

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I'm looking to optimize my WordPress website. The primary area of concern is the page loading speed. I'm already using caching plugins, however, I'm open to suggestions for improvements. The main focus of this project is on the entire website. You should be able to identify areas that can be improved for speed and implement the necessary changes. Ideal skills and experience: - Strong command of WordPress and its optimization tools - Proven experience in improving website loading speeds - Expertise in utilizing caching plugins to their maximum potential

I'm in need of assistance for setting up a PostgreSQL database on my backend GitHub website. The primary purpose of this database is to store user data. Given the nature of my website, it's essential that the database supports concurrent access efficiently. The ideal professional will have: - Proficiency in setting up PostgreSQL databases. - Experience with integrating databases into backend GitHub projects. - Knowledge of concurrent access management in databases.

We have existing wordpress woocommerce and C# MSSQL inventory win application db in azure db I am looking for a developer for backend operations and experience in MSSQL, WordPress wooCommerce and API integrations. The primary task deduct stock in azure ms sql stock table when order placed in wordpress woocommerce display item list in woocommerce based on mssql stock table create comand to generate order in inventory system when order placed in wordpress woocommerce Key Skills Required: - Strong experience with MSSQL, WordPress woocommerce, API - Expertise in inventory management system e-commerce integrations who have done same work earlier plesae bid I will share explaining video, if you are able to do than you need to work on remote zoom or ultraviewer plesae let me know...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I need a proficient expert to help establish, configure, and visualize data using a Power BI server. The data for visualization will be pulled from several resources such as SQL Server, SharePoint, Excel Spreadsheets, and Teradata. Key Responsibilities: - Setup and configure the Power BI server - Connect the server to mentioned data sources - Implement interactive data manipulation capabilities into the Power BI reports Ideal Skills and Experience: - Proficient in Power BI server setup - Experience with SQL, SharePoint, and Teradata - Excel data management skills - Competence in interactive data manipulation and visual analytics - Familiarity with report generation and data analysis Please note that this project requires an emphasis on interactive data manipulation in t...

...menus on my website's mobile version. On the site the BRANDS MENU and the navigation menu are not properly displayed. MENU NOT WORKING ON MOBILE ONLY I think this can be fixed with some JAVASCRIPT and some CSS in the themes but i am not sure I know that this issue happens after changing the database so it can be related but i am not an expert I need a wordpress expert to fix this issue without enabling the JS COMPOSER/WP BAKERY plugin as this causes issues. I give you 5 hours to fix this displaying problem Key Requirements: - Ability to arrange menus in a custom format - the specifics of which we'll discuss in the project's next phase. - Expertise in adjusting menu elements to prevent overlapping, ensuring an optimized and seamless user experience o...

I am in need of a MySQL expert to develop advanced queries for my database management tasks. Key Responsibilities: - Writing new queries: You'll be responsible for designing and implementing new, advanced MySQL queries. - Query Optimization: While the focus is on writing new queries, any optimization suggestions to existing queries are welcome. Ideal Skills: - Proficiency in MySQL: You should have advanced knowledge of MySQL language and its various functions. - Query Optimization: Experience in query optimization will be beneficial. This project is suitable for a MySQL developer with a proven track record in creating complex, high-performance database queries. It's important that you're able to work efficiently and effectively in order ...

As part of my project, I'm searching for an adept mobile app developer who can build a social network app available for both iOS and Android. Key Requirements: - The pivot of the app is to enable social networking capabilities. - A crucial feature of the project involves designing and implementing robust User Profiles. Ideal Candidate: - You are proficient in both iOS and Android app development. - You have previous experience in creating engaging social networking platforms. - You're highly skilled at implementing user profile features, with a keen focus on UI and UX design. I look forward to your innovative ideas and potential collaborations on this exciting project.

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - ...

I am seeking a talented and experienced Mobile Application developer familiar with the Multi-platform App User Interface (MAUI) framework to create a data display mobile application. The specification of the application remains open Skills I am looking for: * Proficiency in MAUI development * Experience in creating apps for multiple platforms * Good understanding of API and database integrations * Ability to provide technical advice and recommendations Your main task will be establishing the foundation of the app considering future functionalities might be added. Your insights and expertise are key, as the specifics beyond data display and the potential requirement for external integrations are still to be determined. Please bid with your projected timeline and prefe...

We are developing a socialization application. Need to find an expert with experience in decoding the application. Attached folder is an example. Looking forward to working with you guys who are really good in this field. Sincere thanks

I'm in need of a professional who can create a straightforward database with a user-friendly GUI for Windows. Key Requirements: - The database should be able to store and retrieve data efficiently. - It should feature a GUI for easy interaction. Ideal Skills and Experience: - Proficiency in Windows database development. - Prior experience in designing user-friendly GUIs. - Strong knowledge of data storage and retrieval techniques. Please let me know about your relevant experience and a rough estimate of the time and cost required for this project. Thank you.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiari...

As a beginner level MySQL user, I am seeking someone to sit with me (virtually) for approximately 2-3 hours to aid me in running certain MySQL commands with some provided databases. Beyond this, I need assistance in creating a new database from scratch. The session will be conducted via Zoom, and it's vital that you have the requisite MySQL software and databases already installed on your own device. My needs during the call include: - Writing MySQL commands - Understanding MySQL commands - Creating a fresh MySQL database Ideal freelancer for this task would have a strong command of MySQL and proven experience in teaching or tutoring, as well as excellent communication skills in English.

...the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data from the Excel files in the “upload” folder to tables in the database. This is done in a similar way for all files and up until a couple of months ago, worked fine for all files, and then suddenly stopped working for only the largest file. Through my own tests, I’ve learned that if I remove the 30 columns prior to the last column in the problematic Excel file, it transfers fine, so it’s not a coding issue. There’s either a problem with too many columns or something in one or more of those 30 columns is causing an er...

As an established business relying heavily on a comprehensive tech stack, I'm in need of a seasoned .NET developer for a variety of tasks. Key responsibilities include: - Review and optimization of existing front-end, back-end, and database systems - Ongoing maintenance, troubleshooting, and improvements to enhance system performance Ideal candidates for this project should have prior experience with: - Front-end development utilizing HTML/CSS - Backend technologies such as SQL Server and Entity Framework - A strong grasp of the .NET framework This role is crucial to the successful functioning of our systems, so a proactive, detail-oriented approach and excellent problem-solving skills are must-haves. Your ability to communicate issues and improvements clearly is als...

I'm looking for a proficient PHP developer who can help me with parameterizing a MySQLi query in my project. Specifically, I need assistance with data retrieval operations. Key requirements: - Proficiency in PHP: You should have a strong grasp of PHP programming. - MySQLi Query Parameterization: The ideal candidate should be experienced in properly parameterizing MySQLi queries. - Data Retrieval: The primary task will be focused on data retrieval operations. The project may include: - Handling multiple parameters: You should be comfortable working with queries that handle multiple parameters at once. - Optimization: Ensuring the queries are optimized and secure. It's a relatively straightforward task for a skilled PHP developer with MySQLi experience. If you...

I'm in need of a versatile software that can record video from endoscope cameras and facilitate the creation of a database from each video. Key requirements: - It should be compatible with Windows and Mac operating systems. - I prefer storing the database locally on the same device. - The software must support video formats AVI and MP4, which are the formats the endoscope cameras I use record in. The ideal freelancer for this project should have experience with: - Developing video recording software - Implementing database management systems - Proficiency in working across Windows and Mac operating systems - Knowledge of AVI and MP4 video formats Please submit your proposal with relevant experience and a clear explanation of how you plan to approach this proj...

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

I need a user-friendly application to assist with the on-site property survey process. This app must be able to capture a comprehensive set of data, In addition to these factors, there will be a requirement for enlisting specific code...development with a preference for those previously involved in projects geared towards real estate or site management. Knowledge of data management and coding for input fields is necessary. This project needs to be completed within the next month so a speedy and efficient working style is crucial. Key Features: - Property repairs information - Property condition recording - search option for a database of codes - Special field for WIP related codes - User-friendly navigation & layout Please ensure you have referenced your relevant work in ...

WordPress & Database Speed Optimization required : 1- Database optimization as one of my plugins is sending queries to DB - some time causing connection Error - or unreachable host Error. 2- Without CDN if possible 3- Including Premium plugin - I have 10 web booster Pro subscription. - If required. 4- Automatic Photo Optimization 5- Permanent solution. 6-Minification - if required. Urgent start up required, who is free and can finish asap.

Cloud Restaurant Website & Mobile App Development I will not be interested in your offer unless I see your Proposals in response to deep reading and understanding of the project requirements (only seniors make bids! The project has a Penalty clause for the deadline) I'm on the lookout for a talented web and mobile app developer who can help bring my cloud restaurant concept to life. Here's what I need: Features: 1. Online Ordering - For easy and convenient customer orders. 2. weekly menu (a page to show our weekly menu) 3. Menu Management - Ability to add, edit, remove, and categorize menu items based on my needs, plus setting item availability. 4. Delivery Tracking - Allowing customers to check their food order status. 5. Nutrition Coaching Reservation - Capa...

I've built a web application using .NET for the backend, Angular for the user interface, and SQL database. Now, I'm looking for someone to help me publish this website on the cloud and make it live. It's a small web app designed for a local business, with a limited number of users (around 15-20). Because of this, I'm aiming to keep costs as low as possible. I'm open to suggestions on which cloud platform would be best suited for this project. If you're interested in taking on this task and helping me get my website up and running, please reach out. Thank you!

I’m looking for an expert with MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this o...

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

**Project Scope** Seeking skilled Data Analyst specializing in PUBG Mobile to elevate our team's performance using data insights. Project goals: * Performance Baseline: Deep understanding of our team's key metrics (individual players & team stats). * Competitive Benchmarking: Analyze opponents to uncover strengths, weaknesses, strategic tendencies. * Optimal Rotation Analysis: Decipher winning map rotation patterns from videos. Find areas we can improve. * Data-Driven Recommendations: Provide clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed for meaningful performa...